Skip to content

today

Today’s date as a serial date number.

v = today

Returns the current date as an integer serial number (no time component). Updates whenever the workbook recalculates.

today % e.g. 46140 = 28-Apr-2026
  • now — Current date and time as a serial date-time number.
  • date — Construct a date serial number from year, month, day.