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.

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