TODAY (Returns the serial number of today's date)

What Does It Do?

Use this to show the current date.

Syntax

=TODAY()

Formatting

No special formatting is needed.

Example

The following example shows how the Today function is used to calculate the number 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.

Example

The following example shows the number of days from today until the year 2000.