Excel Function: TODAY
The Excel function TODAY displays the current date (updated automatically every day).
This function can also be used to calculate the interval between the current date and a date of your choice.
Examples of use
To get today's date, simply enter into a cell:
To calculate the number of days remaining until the date in cell B1, enter:
To get a number of days instead of the date, change the formatting of cell B3:
You will then get the remaining number of days which will be updated every day.