Home » Excel-Built-In-Functions » Excel-Date-And-Time-Functions » Excel-Today-Function

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.

Return to the Excel Date and Time Functions Page
Return to the List of All Built-In Excel Functions