Skip to content

now

Current date and time as a serial date-time number.

v = now

Returns the current date and time as a serial date-time number. The integer part is the date; the fractional part is the time of day (0.5 = noon).

Note: when called from script mode (Programming > Date and Time category), now returns a serial date number using a different epoch convention. The Spreadsheet form here matches Excel’s epoch.

now % e.g. 46140.5612
  • today — Today’s date as a serial date number.
  • date — Construct a date serial number from year, month, day.
  • time — Construct a time fraction from hour, minute, second.