Date & time · Volatile clocks

TODAY vs NOW

Both are volatile clocks with no arguments. TODAY() returns the current date at midnight — a whole-number serial. NOW() returns the current date plus the current time — a serial with a fractional day. They agree on everything date-related and differ only in the time fraction. Because both change with the clock, the scenarios below use time-invariant relations (TODAY ≤ NOW, INT(NOW) = TODAY, equal years) that hold at any instant — measured live, not frozen snapshots.

fx
TODAY(…)  vs  NOW(…)
7
measured relations
0
arguments (both)
1
difference: time fraction
⟳
both volatile
▶ Try both live See the feature matrix
🏆Verdict: TODAY for date-only math; NOW when the time of day matters.

TODAY() and NOW() both return the current date as an Excel serial and both recalculate on every edit (volatile). The difference is precision: TODAY() is midnight of the current date (fractional part 0), while NOW() adds the current time as a fraction of a day. Measured relations confirm they agree on the date — INT(NOW()) = TODAY(), YEAR(TODAY()) = YEAR(NOW()), and the formatted yyyy-mm-dd strings match — and differ only in time: MOD(TODAY(),1) = 0 while NOW()'s fraction lies in [0,1). Use TODAY() for age, deadlines, days-elapsed and any date-only calculation (it stays stable through the day). Use NOW() for timestamps, elapsed-time logging, or anything needing the clock. Neither takes arguments.

TODAY strengths

  • Date only — midnight, fractional part is exactly 0
  • Stable through the day: age/deadline math doesn't jitter
  • Smaller, cleaner serial for date comparisons
  • Ideal for days-elapsed, aging, due-date deltas

NOW strengths

  • Date + time — adds the current clock as a day fraction
  • Recalculates to the instant on every edit
  • INT(NOW()) recovers the same date serial as TODAY()
  • Ideal for timestamps, time logging, intraday elapsed time

Feature-by-feature matrix

Eight dimensions, measured via time-invariant relations. They tie on arguments, date, volatility and availability; they differ only in whether the time of day is included.

CapabilityTODAYNOWWhy it matters
Arguments✓ none — TODAY()✓ none — NOW()Both take zero arguments.
Returns✓ date serial (integer)✓ date + time serialTODAY has fraction 0; NOW has a time fraction.
Time of day✗ midnight only✓ current clockMOD(TODAY(),1)=0; NOW's fraction ∈ [0,1).
Date agreement✓ INT(TODAY())=date✓ INT(NOW())=same dateMeasured: both give the same date serial.
Volatile (recalc)✓ on every edit✓ on every editBoth refresh whenever the sheet recalculates.
Stable within a day✓ yes — date fixed◐ date fixed, time movesTODAY is constant all day; NOW's time advances.
Year / weekday✓ YEAR/WEEKDAY work✓ YEAR/WEEKDAY workMeasured: same year and weekday from both.
Excel version✓ 2007+ (all)✓ 2007+ (all)Both are legacy volatile functions.

Syntax, side by side

No arguments. Excel stores dates as serial numbers (days since 1900-01-00); the fractional part is the time of day.

TODAY

=TODAY()
(none)TODAY takes no arguments. Returns the current date serial at midnight.
=TODAY() → 46342 (2026-11-16, fraction 0)

NOW

=NOW()
(none)NOW takes no arguments. Returns the current date + time serial.
=NOW() → 46342.617… (2026-11-16 plus the current time)

Live head-to-head playground

Both clocks are live and volatile. These presets use relations that hold at any instant, so they stay true as the clock advances — edit them and watch both sides re-evaluate.

A1Sample data — click any cell to edit; both formulas re-evaluate live

TODAY

—

NOW

—
HyperFormula 3.5 · live

Every difference, measured

These are not feature-list claims. Each pair below was evaluated on the identical dataset in the HyperFormula 3.5 engine, and the outputs are baked from that run. Reproduce them in the playground above.

Ordering: TODAY ≤ NOW

Is TODAY always less than or equal to NOW?
TODAY
=TODAY()<=NOW()
TRUE
NOW
=NOW()>=TODAY()
TRUE
TODAY() is midnight of the current date; NOW() is that same date plus the current time. So TODAY() <= NOW() is always TRUE, and NOW() >= TODAY() is always TRUE — measured at this instant and every instant.

Same date serial

Strip the time from NOW — does it equal TODAY?
TODAY
=INT(TODAY())
46342
NOW
=INT(NOW())
46342
INT strips the fractional time. INT(TODAY()) and INT(NOW()) return the identical date serial (46342 for 2026-11-16). This is the proof that they agree on the date.

The time fraction

TODAY's fractional part vs whether NOW's fraction is below 1.
TODAY
=MOD(TODAY(),1)
0
NOW
=MOD(NOW(),1)<1
TRUE
The one real difference: MOD(TODAY(),1) = 0 (TODAY has no time part), while MOD(NOW(),1) < 1 is TRUE (NOW's time fraction lies in [0,1)). TODAY is date-only; NOW carries the clock.

Current year

Extract the year from each.
TODAY
=YEAR(TODAY())
2026
NOW
=YEAR(NOW())
2026
YEAR(TODAY()) = YEAR(NOW()) = 2026. Both see the same date, so the year matches — invariant through the year.

ISO weekday

Day of week (Monday=1) from each.
TODAY
=WEEKDAY(TODAY(),2)
1
NOW
=WEEKDAY(NOW(),2)
1
WEEKDAY(...,2) gives Monday=1. Both return 1 for 2026-11-16 (a Monday). The weekday is a date property, identical for both clocks.

Formatted date

Render just the date part as yyyy-mm-dd.
TODAY
=TEXT(TODAY(),"yyyy-mm-dd")
2026-11-16
NOW
=TEXT(NOW(),"yyyy-mm-dd")
2026-11-16
TEXT(...,"yyyy-mm-dd") renders just the date. Both produce "2026-11-16". NOW only differs if you render the time portion (e.g. hh:mm).

Days since Jan 1

Days elapsed this year, date-only from each.
TODAY
=TODAY()-DATE(2026,1,1)
319
NOW
=INT(NOW())-DATE(2026,1,1)
319
Days since Jan 1 2026: TODAY()-DATE(2026,1,1) = 319, and INT(NOW())-DATE(2026,1,1) = 319. Same date-only count; INT keeps NOW from adding a fractional day.

Engine benchmark

Relative engine cost of evaluating each volatile clock repeatedly. Values are live (they change with the clock); the benchmark measures evaluation cost, not the returned serial.

Table sizeTODAYNOW
1,000 rows × 200 lookups8.16 ms4.25 ms
5,000 rows × 200 lookups5.68 ms2.5 ms
Measured in the HyperFormula 3.5 engine on this page, not in Microsoft Excel. TODAY and NOW are volatile — they recalculate on every edit. Times here are relative engine cost only; the values themselves are live and change with the clock.

Which one should you use?

Choose by whether the time of day matters to your calculation.

SituationUseWhy
Age / days-elapsed / tenureTODAYTODAY() is stable all day, so the count doesn't jitter intraday.
Due-date delta / deadline countdownTODAYDate-only math wants midnight, not the current second.
Timestamp a recordNOWNOW() captures the exact instant, date and time.
Elapsed-time loggingNOWSubtract two NOW() calls to measure intraday duration.
Current year / month / weekdayEitherBoth agree on the date; YEAR/MONTH/WEEKDAY give the same answer.
Compare to a date serialTODAYTODAY()'s zero fraction makes clean date comparisons.
Recover date from a timestampNOWINT(NOW()) strips the time, yielding TODAY()'s serial.
Static, non-refreshing dateEitherNeither — both are volatile; use a hardcoded DATE() or Ctrl+; instead.

TODAY ↔ NOW migration

Swap is trivial (no arguments). To make NOW behave like TODAY, wrap it in INT; to add time to TODAY, you can't — use NOW.

TaskTODAY / old wayNOWWhat changed
Current date serial=TODAY()=INT(NOW())INT strips NOW's time fraction, matching TODAY.
Days since Jan 1=TODAY()-DATE(2026,1,1)=INT(NOW())-DATE(2026,1,1)Same count; INT keeps NOW date-only.
Current year=YEAR(TODAY())=YEAR(NOW())Identical — both see the same date.
Formatted date=TEXT(TODAY(),"yyyy-mm-dd")=TEXT(NOW(),"yyyy-mm-dd")Same date string; NOW only differs if you render the time.
Full timestamp=TODAY()=NOW()TODAY can't show time; NOW is the only choice for a timestamp.

Frequently asked questions

What is the difference between TODAY and NOW?
TODAY() returns the current date at midnight (a whole-number serial, fractional part 0). NOW() returns the current date plus the current time (a serial with a fractional day). They agree on the date and differ only in the time of day. Both take no arguments and both are volatile.
Does INT(NOW()) equal TODAY()?
Yes — measured. INT removes the fractional time part of NOW(), leaving the date serial, which equals TODAY(). The relation INT(NOW()) = TODAY() holds at any instant within the day. This is the standard way to get a date-only value from a timestamp.
Why do the scenarios use relations instead of plain values?
Because TODAY and NOW are volatile — their exact serials change with the clock, so a frozen snapshot would be stale the moment you read it. Relations like TODAY()<=NOW(), YEAR(TODAY())=YEAR(NOW()) and equal formatted dates hold at any instant, so they can be measured live and stay true. This page proves the difference rigorously rather than showing a drifting number.
Are TODAY and NOW volatile?
Yes. Both recalculate whenever the worksheet recalculates (on any edit, or on open). TODAY changes only when the date rolls over; NOW changes continuously as the clock advances. If you need a static date that never refreshes, type it with Ctrl+; (date) or Ctrl+Shift+; (time) instead.
How do I get just the time from NOW()?
Subtract the date: NOW()-INT(NOW()) returns the fractional day (the time). Format it as a time to read hours/minutes/seconds. TODAY() has no time part — MOD(TODAY(),1) is always 0 — so you cannot extract a time from TODAY.
Which should I use for age or deadline calculations?
TODAY(). Age, tenure, days-elapsed and deadline countdowns are date-only concepts; TODAY()'s midnight value stays stable through the day so the result doesn't jitter. Using NOW() would add a fractional day that changes intraday and can off-by-one a boundary comparison.