The Excel TODAY Function

Related Function:
NOW function

Function Description

The Excel Today function returns the current date. The function has no arguments and therefore, the syntax of the function is simply:

TODAY()

Today Function Examples

Example 1

The following spreadsheet shows a call to the Excel Today function, which was made on 1st September 2015.

 Formula:
  A
1 =TODAY()
 Result:
  A
1 01-Sep-2015

Example 2

The example below shows the Excel Today function used as a part of a formula that calculates the number of days that have passed since 01-Jan-2013. Again, the date at the time of the function call was 1st September 2015.

 Formula:
  A B
1 01-Jan-2013 =TODAY() - A1
 Result:
  A B
1 01-Jan-2013 973

For further information and examples of the Excel Today function, see the Microsoft Office website.