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.