Formula Functions > Functions T to Z > TODAY |
This function returns the date and time of the current date.
TODAY()
This function does not accept arguments.
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.
Does not accept data. Returns a DateTime object.
If today is the 14th of November in the year 2003, then
TODAY() gives the result November 14, 2003 12:00:00AM
This function is available in product version 1.0 or later. This function is a volatile function in version 2.5 or later.
DATE | DAY | NOW | TIME | Date and Time Functions