Skip to main content

TODAY

The TODAY function returns the current date.

This function can be useful for automatically updating the date in your spreadsheets.

Syntax​

TODAY()

No arguments are allowed for this function.

Examples of use​

Retrieving the current date

=TODAY()

Result: current date, for example, 01/01/2025.

Adding days to the current date

=TODAY()+7

Result: the date that will be 7 days from the current date.

Notes​

  • The function value is updated when you open the file, change any cell, insert or delete rows or columns, rename or move a sheet, manually recalculate data, or change the calculation mode from “Manual” to “Automatic.”
  • The function returns only the date, without the time. To display the current date and time, use the NOW function.