The NOW function returns a date/time value that’s the current time in the file’s time zone.
NOW()
Notes
The NOW 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 and time are updated every time you open the file or change a table.
Example |
|---|
=NOW() returns Jul 18, 2011 08:41 am, if calculated at 8:41 a.m. on July 18, 2011. |