Date & time · timestamps · Nov 2026

The NOW function,
measured & explained.

A measured NOW gallery: the date/time serial, its relationship to TODAY, the time fraction and volatility — every assertion engine-verified. Live, free.

D1
fx
=NOW()
0
measured gallery rows
0
sourced errors fixed
0
platforms checked
// 01 — Anatomy

How NOW works

Zero arguments. Returns a volatile date+time serial number. INT(NOW())=TODAY(); NOW()-TODAY() is the time fraction.

=NOW()
no argumentsNOW() takes none; it returns the current date+time serial.
vs TODAYTODAY() is date-only; INT(NOW())=TODAY().
volatilityRecalculates on every edit; freeze with Paste Special → Values.
.bool-moat td.res-text{color:var(--cyan);font-weight:700;font-family:var(--mono)}
// 02 — Date & time

What NOW returns

NOW() returns the current date and time as a serial number; TODAY() returns just the date (midnight). The integer part of NOW equals TODAY, and the fractional part is the time of day. NOW is volatile — it recalculates on every edit. The gallery uses date-stable assertions (booleans and the year) plus snapshot readings, all measured live. Click any row.

Measured NOW gallery

ExpressionResultWhy
=ISNUMBER(NOW())TRUENOW is a number
=INT(NOW())=TODAY()TRUEDate part equals TODAY
=NOW()>=TODAY()TRUEAt or after midnight
=NOW()-TODAY()<1TRUEFraction is time of day
=YEAR(NOW())2026Current year
=NOW()>DATE(2026,1,1)TRUEAfter 1 Jan 2026
=TEXT(NOW(),"yyyy")2026Year as text
=SECOND(NOW())>=0TRUESeconds are valid

Date + time, decomposed (static)

ExpressionResultWhy
=ISNUMBER(NOW())TRUENOW is a serial number, not text
=INT(NOW())=TODAY()TRUEThe date part equals TODAY
=NOW()-TODAY()0..1The fractional part is the time of day (0.5 = noon)
=YEAR(NOW())2026The current year (stable within the year)
=NOW()=TODAY()FALSEAlmost never equal — NOW carries a time fraction
⚠ NOW() takes no arguments — NOW(A1) is an error. And because it is volatile, a sheet full of NOW() formulas recalculates constantly and can slow large workbooks. For a fixed timestamp use Ctrl+; (date) and Ctrl+Shift+; (time), or paste NOW() as a value.
Use it well: NOW() for elapsed-time math (end − start), live clocks and 'as of' stamps; TODAY() when only the date matters. Freeze a timestamp with copy → Paste Special → Values. Extract the time alone with =NOW()-TODAY() formatted as time.
// 03 — Try it live

Interactive NOW playground

Booleans and YEAR are date-stable; MONTH/DAY presets are build-date snapshots that advance with the clock.

A1Sample data — click any cell to edit, the formula re-evaluates live
Result
—
✓ readyHyperFormula 3.5
// 04 — Error library

The real-world error library

10 failure patterns mined from actual user reports on Reddit, Stack Overflow and Super User — each with the authentic symptom, root cause, a fix, and a runnable formula. Not textbook theory.

// 05 — Cross-platform

Where NOW works

NOW and TODAY are universal, zero-argument volatile functions across all Excel versions, Google Sheets and LibreOffice. Both use the local system clock.

PlatformSupportNotesGotcha
✓ Supported full NOW◐ Partial works with caveatsCompiled from public docs · verify against your build
// Go deeper

Master date and time

NOW is one piece. The full course walks the toolkit end to end with live, measured examples.

  • NOW vs TODAY — date+time vs date-only
  • The serial: integer date + fractional time
  • Volatility and freezing timestamps
  • Elapsed-time math with NOW
Free while in beta
Browse the function library

No account needed. Every page has a live playground.

// 07 — FAQ

Frequently asked