Current Date in Microsoft Excel

In this tutorial, you will learn how to get current date in Microsoft Excel using TODAY and NOW functions in Excel.

TODAY, NOW and Static date and time are the functions that will help us get the desired result.

TODAY function in Excel

This function is =TODAY(). By simply entering this you’ll get the current date.

Current Date in Excel

NOW function in Excel

This function gives both the current date and time, =NOW().

Current Date in Excel

Static Date and Time in Excel

To make the current time date and time as static use control keys Ctrl+; . Using this control key makes the current date and time static.

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Hey, wait!Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.