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():


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