TODAY
What Does It Do?
=TODAY()
Formatting
The result will normally be displayed using the DD-MMM-YY format.
Example
The following example shows how the Today function is used to calculate the number
of days since a particular day.
of days since a particular day.
Note that the result is actually the number of days before todays date. To calculate
a result which includes the current date an extra 1 will need to be added.
a result which includes the current date an extra 1 will need to be added.
Example