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 Jul 18, 2015, when calculated anytime on July 18, 2015. |