Excel TODAY Function: Complete Guide
TODAY returns the current date — no arguments, no complications. But because it's volatile (updates constantly), most Excel users get one thing wrong: they use it when they should be pressing Ctrl + ; instead.
Syntax
TODAY takes zero arguments. The parentheses are still required — =TODAY alone won't work; it must be =TODAY().
What TODAY returns
The current date as an Excel date value (a serial number displayed as a date). No time component. Excel treats it as midnight (00:00:00) of the current day.
Basic use
=TODAY()
Common uses
1. Days until a deadline
Days remaining
=A1 - TODAY()
Format the result cell as a number (General), not as a date, or Excel will show the difference as another date.
2. Age calculation
Age in complete years
=DATEDIF(A1, TODAY(), "Y")
3. Is it today?
Compare a date to today
=IF(A1 = TODAY(), "Today", "Other day")
4. Highlight overdue rows (conditional formatting)
Select your date column → Conditional Formatting → New Rule → Use a formula:
=A1 < TODAY()
Any date before today gets highlighted. Perfect for task lists, invoices, or SLAs.
5. Time-of-year calculations
Days into the year
=TODAY() - DATE(YEAR(TODAY()), 1, 1) + 1
The volatile function trap
TODAY is a volatile function — it recalculates every time the workbook recalculates. That happens:
- When you open the file
- When you edit any cell
- When you press F9
- When Excel decides to recalculate (auto-mode)
This is usually what you want for age or "days until" calculations. But if you're stamping a record ("date created" for a row), you don't want it changing. Use one of the alternatives below.
Freezing a date (static entry)
To insert today's date as a fixed value that never changes:
Keyboard shortcut
Ctrl + ; (semicolon)
For time only: Ctrl + Shift + ;. For both: enter the date shortcut, space, then the time shortcut.
TODAY vs. NOW
| Function | Returns | Updates | Best for |
|---|---|---|---|
TODAY() | Date at midnight | On recalc | Day math, age, deadlines |
NOW() | Date + time to the second | On recalc (constantly) | Timestamps, elapsed time |
| Ctrl+; | Today's date (static) | Never | Records that shouldn't move |
| Ctrl+Shift+; | Current time (static) | Never | Time stamps that stay put |
Common pitfalls
If you compute =A1 - TODAY() and format as a date, Excel interprets the result (a number like 116) as a serial date. Format the result cell as General or Number.
Using =TODAY() to log a "date created" means the timestamp changes every recalc. Use Ctrl+; for one-time stamps. For automated timestamps in tables, use Power Query or a small VBA macro.
If A1 contains "2026-09-06" as text (not a date), =A1 = TODAY() returns FALSE even if the dates match. Convert with =DATEVALUE(A1) = TODAY().
Every volatile function forces recalculation of dependent cells. In sheets with thousands of TODAY references, performance suffers. Consolidate into one cell (e.g., cell Z1 = TODAY()) and reference that cell everywhere.
TODAY in Google Sheets
Google Sheets has an identical TODAY function. Same syntax, same behavior — volatile, no arguments, returns the current date. Also has TODAY() equivalents for keyboard: Ctrl+; for static date in Sheets.
Related functions
Date math in plain English
Age calculations, "days until", and business-day math have different function combos. Excel Wizard takes your intent — "days until Christmas from today" — and writes the correct formula, complete with TODAY, DATE, or NETWORKDAYS as needed.
Install Excel Wizard →Frequently asked questions
What does TODAY do in Excel?
TODAY returns the current date with no time component. Takes no arguments — just =TODAY(). Updates each time the workbook recalculates.
How do I stop TODAY from changing every day?
TODAY is volatile — it always updates. To freeze a date, press Ctrl + ; to insert today's date as a static value instead of using the function.
What's the difference between TODAY and NOW?
TODAY returns just the date at midnight. NOW returns date and time to the second. TODAY updates at file open and recalc; NOW updates constantly.
How do I calculate age using TODAY?
Use =DATEDIF(birthday, TODAY(), "Y") to get age in complete years. Because TODAY updates, the age recalculates automatically each day.