Date & time · the volatile date · Nov 2026

The TODAY function,
measured & explained.

Syntax, a live playground, a measured date gallery, TODAY vs NOW, date-difference math, and a sourced error library: the volatile TODAY function.

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

How TODAY works

Returns the current date as a serial number. Volatile: it updates automatically. Available since Excel 2003.

=TODAY()
no argumentsTODAY() takes none; it returns the current date.
serialThe result is a date serial number with zero time.
volatileIt recalculates on every change, open and F9.
.bool-moat td.res-text{color:var(--cyan);font-weight:700;font-family:var(--mono)}
// 02 — The volatile date

What TODAY actually returns

TODAY returns the current date as a serial number and is volatile — it recalculates on every change and reopen. The gallery below are measured Nov 16, 2026 snapshots; in the live playground they update to your real date. Every row was measured live in HyperFormula. Click any row to load it.

Date gallery — measured Nov 16, 2026

ExpressionResultWhy
=YEAR(TODAY())2026Current year
=MONTH(TODAY())11Current month (Nov snapshot)
=DAY(TODAY())16Current day (Nov 16 snapshot)
=TODAY()>DATE(2026,1,1)TRUEToday is after New Year
=ISNUMBER(TODAY())TRUETODAY returns a serial number
=IF(TODAY()>DATE(2026,6,30),"H2","H1")H2Half-of-year branch
=WEEKDAY(TODAY(),2)1ISO weekday (Mon=1; Nov 16 2026)
=TODAY()-DATE(2026,1,1)319Days since New Year (Nov 16 snapshot)

TODAY vs NOW, and date-difference patterns

ExpressionResultWhy
=TODAY()46342date only (serial); time = 00:00
=NOW()46342.03date + time; fractional serial
=TODAY()-DATE(2026,1,1)319days between two dates
=DATE(2026,12,31)-TODAY()45days remaining in the year
=TEXT(TODAY(),"yyyy")2026format the year as text
⚠ TODAY is volatile: it recalculates on every edit, open and F9, so a baked result drifts daily. Never hard-code a date you want to stay current — use TODAY(). For a fixed timestamp use Ctrl+; (date) or Ctrl+Shift+; (time), which insert a static value.
Excel stores dates as serial numbers (days since 1900-01-01), so date math is subtraction: TODAY()-DATE(2026,1,1) = 319 days. TODAY() has no arguments and zero time; NOW() adds the current time as a fraction of a day.
// 03 — Try it live

Interactive TODAY playground

Edit the table or type any formula — the HyperFormula engine evaluates it instantly with your real current date. Load a preset to extract the year, count days since New Year, and branch on the half-year.

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

The real-world error library

8 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 TODAY works

TODAY is available across modern Excel, Google Sheets and LibreOffice. It has been in Excel since 2003.

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

Master date & time

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

  • TODAY vs NOW — date vs timestamp
  • Date math: subtracting serial numbers
  • The volatile-recalculation behavior
  • YEAR / MONTH / DAY / WEEKDAY extraction
Free while in beta
Browse the function library

No account needed. Every page has a live playground.

// 07 — FAQ

Frequently asked