# TODAY function in Excel

> TODAY returns the current date, with no time attached, and updates every time the workbook recalculates.

Source: https://spreadsheetpractice.com/functions/today · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

## Quick answer

- **What it does:** TODAY returns the current date, with no time attached, and updates every time the workbook recalculates.
- **Syntax:** `=TODAY()`
- **Most common use:** `=TODAY()` returns Nov 20, 2026 (Today's date; it changes every day)
- **Available in:** Every current version
- **Category:** [Date functions](https://spreadsheetpractice.com/functions/category/date)
- **Returns:** Today's date as a serial number, which changes each day.
- **Google Sheets:** Works the same in Google Sheets.

## What it does

TODAY returns the current date, with no time attached, and updates every time the workbook recalculates. Use it for anything relative to now: days until a deadline, days overdue, or ages that stay current without editing. It takes no arguments, but the parentheses are required.

## Syntax

`=TODAY()`



## Examples

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| D2 | `=TODAY()` | Nov 20, 2026 | Today's date; it changes every day |
| D3 | `=B2-TODAY()` | 342 | Days left until the domain renewal, counted from today |
| D4 | `=IF(B3<TODAY(),"Overdue","On time")` | Overdue | Flags the report if its due date has passed |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D |
|---|---|---|---|---|
| 1 | Task | Due date |  | Result |
| 2 | Renew domain | 10/28/2027 |  | Nov 20, 2026 |
| 3 | File report | 1/15/2026 |  | 342 |
| 4 |  |  |  | Overdue |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| Days-until results show as dates | Subtracting dates can pick up a date format, so 45 shows as 2/14/1900. Format the result cell as Number or General. |
| A typed date that never updates | Pressing Ctrl+; enters today's date as a fixed value. Use =TODAY() when the date should move each day. |
| Results change between opening the file | That is TODAY working as designed. If you need a fixed "as of" date for a report, type the date in a cell and reference that instead. |

## Tips

- Use =NOW() when you also need the current time; TODAY returns the date only.

## Related functions

- [DATEDIF](https://spreadsheetpractice.com/functions/datedif): DATEDIF counts the complete years, months or days between two dates.
- [DAYS](https://spreadsheetpractice.com/functions/days): DAYS returns the number of days between two dates.
- [NETWORKDAYS](https://spreadsheetpractice.com/functions/networkdays): NETWORKDAYS counts the working days between two dates, Monday to Friday, including both the start and end date.

## Questions

### How do I calculate days until a date in Excel?

Subtract today from the date: =A2-TODAY(). Format the result as a number. Negative results mean the date has passed.

### Why does my TODAY formula show a different date tomorrow?

TODAY is volatile: it recalculates whenever the workbook does. Type a date into a cell if you need it to stay fixed.

### Does TODAY include the time?

No. TODAY returns midnight of the current date. NOW returns the date and time.

## Practice

A graded TODAY exercise ("Days until due") is on [the TODAY page](https://spreadsheetpractice.com/functions/today). It is checked instantly, then re-checked on changed data.

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
