TODAY Function
Returns today's date, updated every time the workbook recalculates.
Category
Date & Time
Available in
All versions, Microsoft 365
Returns
Today's date (serial number)
Overview
TODAY returns the current date with no time attached. It takes no arguments — the brackets stay empty.
It's volatile: it updates whenever the workbook recalculates or reopens, which makes it ideal for countdowns, ages and overdue flags.
Syntax
This function takes no arguments — the brackets stay empty.
Examples
Example 1 — Days until each invoice is due
Subtract today from the due date. (These results assume today is 3/15/2026.)
| A | B | C | |
|---|---|---|---|
| 1 | Invoice | Due date | Days left |
| 2 | INV-101 | 3/20/2026 | 5 |
| 3 | INV-102 | 3/31/2026 | 16 |
| 4 | INV-103 | 3/10/2026 | -5 |
A negative number means the invoice is overdue. Format the result column as General or Number, not Date.
Example 3 — Age in whole years
DATEDIF counts complete years between a birth date and today.
Common mistakes
- The date I typed yesterday has changed. TODAY always shows the current date. To stamp a date that never changes, press Ctrl + ; instead.
- The result looks like 46096. The cell is formatted as General. Format it as Short Date.
Notes
- Shortcut: Ctrl + ; types today's date as a fixed value; Ctrl + Shift + ; types the current time.
- Related functions: NOW, DATEDIF, NETWORKDAYS, WORKDAY.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.