Syntax, a live playground, a measured date gallery, TODAY vs NOW, date-difference math, and a sourced error library: the volatile TODAY function.
Returns the current date as a serial number. Volatile: it updates automatically. Available since Excel 2003.
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.
| Expression | Result | Why |
|---|---|---|
| =YEAR(TODAY()) | 2026 | Current year |
| =MONTH(TODAY()) | 11 | Current month (Nov snapshot) |
| =DAY(TODAY()) | 16 | Current day (Nov 16 snapshot) |
| =TODAY()>DATE(2026,1,1) | TRUE | Today is after New Year |
| =ISNUMBER(TODAY()) | TRUE | TODAY returns a serial number |
| =IF(TODAY()>DATE(2026,6,30),"H2","H1") | H2 | Half-of-year branch |
| =WEEKDAY(TODAY(),2) | 1 | ISO weekday (Mon=1; Nov 16 2026) |
| =TODAY()-DATE(2026,1,1) | 319 | Days since New Year (Nov 16 snapshot) |
| Expression | Result | Why |
|---|---|---|
| =TODAY() | 46342 | date only (serial); time = 00:00 |
| =NOW() | 46342.03 | date + time; fractional serial |
| =TODAY()-DATE(2026,1,1) | 319 | days between two dates |
| =DATE(2026,12,31)-TODAY() | 45 | days remaining in the year |
| =TEXT(TODAY(),"yyyy") | 2026 | format the year as text |
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.
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.
TODAY is available across modern Excel, Google Sheets and LibreOffice. It has been in Excel since 2003.
| Platform | Support | Notes | Gotcha |
|---|
TODAY is one piece. The full course walks the toolkit end to end with live, measured examples.