Definition of TODAY

Returns the current date as a date value.

Syntax

TODAY()

Notes

  • Note that TODAY is a volatile function and can hurt spreadsheet performance.
  • TODAY provides the current date with no time component. To create a date with the current time, use NOW.
  • TODAY will always represent the current date the last time the spreadsheet was recalculated, rather than remaining at the date when it was first entered.

See Also

NOW: Returns the current date and time as a date value.

DATEVALUE: Converts a provided date string in a known format to a date value.

DATE: Converts a provided year, month, and day into a date.

In order to use the TODAY formula, start with your edited Excellentable

Then type in the TODAY Formula in the area you would like to display the outcome:

By adding the values you would like to calculate, Excellentable generates the outcome:

Error.

User does not have sufficient privileges to access this Content
Learn More