The TODAY function returns the current date in the file’s time zone. 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 file’s time zone matches the time zone on the Mac where the file was last saved.
The displayed date is updated every time you open the file or change a table.
You can use the NOW function to get the current date and time and format the cell to display both.
Example |
|---|
=TODAY() returns Jul 18, 2015, when calculated anytime on July 18, 2015. |