This function returns the date and time of the current date.

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 DateTime object.

Examples

If today is the 14th of November in the year 2003, then

TODAY() gives the result November 14, 2003 12:00:00AM

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.

See Also

DATE | DAY | NOW | TIME | Date and Time Functions