The Excel TODAY Function

Related Function:
NOW function

Basic 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
101-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:
 AB
101-Jan-2013=TODAY() - A1
 Result:
 AB
101-Jan-2013973

Further information and examples of the Excel Today function are provided on the Microsoft Office website.