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).
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 :
You will probably see this result :
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.