The TODAY function displays the current date regardless of when it was opened, and for calculating intervals. It always reflects the current date.
-
Enter =TODAY() to return the current date, while entering =TODAY()+5 will return the current date plus five days.
-
Enter =DATEVALUE("1/1/2030")-TODAY() to return the number of days between the current date and 1/1/2030.
-
Enter =DAY(TODAY()) to return the current day of the month (1-31), and entering =MONTH(TODAY()) returns the month of the year (1-12).
Tip: Use Control+: (colon) to insert today's that never changes.
The TODAY function is useful to put the current date displayed on a worksheet regardless of when it was opened, and for calculating intervals.
-
Enter =TODAY() to return the current date, while entering =TODAY()+5 will return the current date plus five days.
-
Enter =DATEVALUE("1/1/2030")-TODAY() to return the number of days between the current date and 1/1/2030.
-
Enter =DAY(TODAY()) to return the current day of the month (1-31), and entering =MONTH(TODAY()) returns the month of the year (1-12).
Tip: Use Ctrl+; (semi-colon) + Enter to insert today's date that never changes.