Formualizer Docs
ReferenceFunctionsDate & Time Functions

TODAY

TODAY: Returns the current date as a volatile serial value.

Summary

Returns the current date as a volatile serial value.

Remarks

  • TODAY is volatile and recalculates each time the workbook recalculates.
  • The result is an integer date serial with no time fraction.
  • Serial output respects the active workbook date system (1900 or 1904).

Examples

TODAY has no time fraction
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
true
Date arithmetic with TODAY
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
7

FAQ

Will TODAY include a time-of-day fraction?

No. TODAY always returns an integer serial date, so its fractional part is always 0.

Runtime metadata

Category

Date & Time

Signature

TODAY()

Arity

min 0, max 0

Caps

VOLATILE

Source

crates/formualizer-eval/src/builtins/datetime/today_now.rs

TIMEVALUE

TIMEVALUE: Parses a time string and returns its fractional-day serial value.

WEEKDAY

WEEKDAY: Returns the day-of-week index for a date serial with configurable numbering.

On this page

SummaryRemarksExamplesRelated functionsFAQWill TODAY include a time-of-day fraction?Runtime metadata