What's the Date Today (Today Function in Excel)

 

What Does It Do?

Use this to show the current date.

Syntax

=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.

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.