Formualizer Docs
ReferenceFunctionsDate & Time Functions

NOW

NOW: Returns the current date and time as a volatile datetime serial.

Summary

Returns the current date and time as a volatile datetime serial.

Remarks

  • NOW is volatile and may produce a different value at each recalculation.
  • The integer part is the current date serial; the fractional part is time of day.
  • Serial output respects the active workbook date system (1900 or 1904).

Examples

NOW includes today's date
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
true
NOW is at or after TODAY
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
true

FAQ

How do I isolate only the time portion from NOW?

Use NOW()-INT(NOW()); the integer part is date serial and the fractional part is time-of-day.

Runtime metadata

Category

Date & Time

Signature

NOW()

Arity

min 0, max 0

Caps

VOLATILE

Source

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

NETWORKDAYS

NETWORKDAYS: Returns the number of weekday business days between two dates, inclusive.

SECOND

Extracts the second component (`0` to `59`) from a time or datetime serial.

On this page

SummaryRemarksExamplesRelated functionsFAQHow do I isolate only the time portion from NOW?Runtime metadata