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.
NOW function in Excel
This function gives both the current date and time, =NOW().
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.