Excel TODAY Function: Complete Guide (2026)
ExcelFunction Reference⏱ 6 min read

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()

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()
Result: September 6, 2026 (or whatever today is)

Common uses

1. Days until a deadline

Days remaining

=A1 - TODAY()
If A1 = Dec 31, 2026 → Result: 116 (days remaining)

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")
If A1 = 1990-05-15 → Result: 36 years

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
On Sep 6, 2026 → Result: 249 (249 days into the year)

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)
Inserts today's date as a static value. Never updates.

For time only: Ctrl + Shift + ;. For both: enter the date shortcut, space, then the time shortcut.

TODAY vs. NOW

FunctionReturnsUpdatesBest for
TODAY()Date at midnightOn recalcDay math, age, deadlines
NOW()Date + time to the secondOn recalc (constantly)Timestamps, elapsed time
Ctrl+;Today's date (static)NeverRecords that shouldn't move
Ctrl+Shift+;Current time (static)NeverTime stamps that stay put

Common pitfalls

Formatting as date shows weird results

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.

Timestamps that keep moving

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.

Comparing TODAY to a text date

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().

Use TODAY sparingly in large workbooks

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

Related

NOW

Like TODAY but includes current time to the second.

Related

DATE

Constructs a date from year, month, day components.

Related

DATEDIF

Difference between dates in years, months, or days.

Related

EOMONTH

Last day of the month N months away.

Excel Wizard

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.