TODAY

This function returns a serial number representing the current date in Excel. The results are updated as soon as the worksheet is opened or refreshed.

Syntax

TODAY()

Arguments

This function does not accept arguments.

Remarks

If you use this function in a date-time cell (DateTimeCellType), the cell formats the value using the date format settings.

This function is updated only when the spreadsheet or cell containing the function is recalculated. This is a volatile function with version 2.5 or later.

Data Types

Does not accept data. Returns a numeric value (a serial number) that represents the current date in Excel.

Examples

If today is the 13th of February in the year 2019, then

TODAY() gives the result 43509.

Version Available

This function is available in product version 1.0 or later. This function is a volatile function in version 2.5 or later.

Note: If a user uses LegacyBehaviors.CalculationEngine, TODAY function will return the DateTime object instead of the serial numeric value. For more details, please refer to breaking changes for legacy behaviors.