Excel function TODAY

The TODAY function returns today's date (updated every day). This function is great for figuring out how many days there are between today and a specified date (the difference between two dates).


Today's date

Enter =TODAY() in a cell, and the function will return today's date (this function has no parameters).

Example of a possible purpose: calculating the difference between two dates in days:

Enter =your_date-TODAY():

today - today

You will probably see this result:

today2 - today

Edit the cell format so that a number rather than a date is displayed ...

The result will be the difference in days. This will be updated every day.

days left - today