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