Formulas and Functions
Modifying this control will update this page automatically

TODAY

The TODAY function returns the current date in the file’s time zone (see Notes below). The time is set to 12:00 a.m.

TODAY()

Notes

  • The TODAY function does not have any arguments. However, you must include the parentheses.

  • The displayed date is updated every time you open the file or change a table.

  • The time zone for a local macOS file: The file’s time zone matches the time zone in the Date & Time settings on the Mac when the file was last saved.

  • The time zone for a local iOS or iPadOS file: The file’s time zone matches the time zone in your Date & Time settings when the file is opened or saved.

  • The time zone for an iCloud file: The file’s time zone matches the time zone in iCloud settings when the file is first created. If the file is opened and saved in a local app (not in iCloud), the time zone is updated to match the settings on the device where the app is located.

  • The time zone for a file shared with collaborators: The file’s time zone continues to match the time zone in iCloud settings where the file was first shared, unless you unshare it and save it in a local app (not in iCloud).

  • You can use the TODAY function to get the current date and time and format the cell to display both.

  • To use TODAY as a static date stamp, you can select the cell that contains it, choose Edit > Copy, select the cell where you want the time stamp, then choose Edit > Paste Formula Results to paste the date as static (unchanging) text.

Example

=TODAY() returns 18 Jul 2015, when calculated anytime on 18 July 2015.

See alsoNOW
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Helpful?
Character limit: 250
Maximum character limit is 250.
Thanks for your feedback.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.