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.
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.
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.
| Capability | TODAY | NOW | Why it matters |
|---|---|---|---|
| Arguments | ✓ none — TODAY() | ✓ none — NOW() | Both take zero arguments. |
| Returns | ✓ date serial (integer) | ✓ date + time serial | TODAY has fraction 0; NOW has a time fraction. |
| Time of day | ✗ midnight only | ✓ current clock | MOD(TODAY(),1)=0; NOW's fraction ∈ [0,1). |
| Date agreement | ✓ INT(TODAY())=date | ✓ INT(NOW())=same date | Measured: both give the same date serial. |
| Volatile (recalc) | ✓ on every edit | ✓ on every edit | Both refresh whenever the sheet recalculates. |
| Stable within a day | ✓ yes — date fixed | ◐ date fixed, time moves | TODAY is constant all day; NOW's time advances. |
| Year / weekday | ✓ YEAR/WEEKDAY work | ✓ YEAR/WEEKDAY work | Measured: same year and weekday from both. |
| Excel version | ✓ 2007+ (all) | ✓ 2007+ (all) | Both are legacy volatile functions. |
No arguments. Excel stores dates as serial numbers (days since 1900-01-00); the fractional part is the time of day.
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.
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.
=TODAY()<=NOW()=NOW()>=TODAY()=INT(TODAY())=INT(NOW())=MOD(TODAY(),1)=MOD(NOW(),1)<1=YEAR(TODAY())=YEAR(NOW())=WEEKDAY(TODAY(),2)=WEEKDAY(NOW(),2)=TEXT(TODAY(),"yyyy-mm-dd")=TEXT(NOW(),"yyyy-mm-dd")=TODAY()-DATE(2026,1,1)=INT(NOW())-DATE(2026,1,1)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 size | TODAY | NOW |
|---|---|---|
| 1,000 rows × 200 lookups | 8.16 ms | 4.25 ms |
| 5,000 rows × 200 lookups | 5.68 ms | 2.5 ms |
Choose by whether the time of day matters to your calculation.
| Situation | Use | Why |
|---|---|---|
| Age / days-elapsed / tenure | TODAY | TODAY() is stable all day, so the count doesn't jitter intraday. |
| Due-date delta / deadline countdown | TODAY | Date-only math wants midnight, not the current second. |
| Timestamp a record | NOW | NOW() captures the exact instant, date and time. |
| Elapsed-time logging | NOW | Subtract two NOW() calls to measure intraday duration. |
| Current year / month / weekday | Either | Both agree on the date; YEAR/MONTH/WEEKDAY give the same answer. |
| Compare to a date serial | TODAY | TODAY()'s zero fraction makes clean date comparisons. |
| Recover date from a timestamp | NOW | INT(NOW()) strips the time, yielding TODAY()'s serial. |
| Static, non-refreshing date | Either | Neither — both are volatile; use a hardcoded DATE() or Ctrl+; instead. |
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.
| Task | TODAY / old way | NOW | What 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. |