---
title: "TODAY function in Excel: syntax and examples | ExcelSavvy"
description: "How to use TODAY in Excel and Google Sheets: days until a deadline, ages and other date math from today."
canonical_url: "https://excelsavvy.com/functions/today"
meta:
  "og:description": "How to use TODAY in Excel and Google Sheets: days until a deadline, ages and other date math from today."
  "og:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~VE9EQVkgZnVuY3Rpb24gaW4gRXhjZWw6IHN5bnRheCBhbmQgZXhhbXBsZXM%2Cdescription_~SG93IHRvIHVzZSBUT0RBWSBpbiBFeGNlbCBhbmQgR29vZ2xlIFNoZWV0czogZGF5cyB1bnRpbCBhIGRlYWRsaW5lLCBhZ2VzIGFuZCBvdGhlciBkYXRlIG1hdGggZnJvbSB0b2RheS4%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_TODAY()%2Cp_Ii9mdW5jdGlvbnMvdG9kYXki%2Cs_MbS_3SVbtZABuH7o.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "TODAY function in Excel: syntax and examples | ExcelSavvy"
  "twitter:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~VE9EQVkgZnVuY3Rpb24gaW4gRXhjZWw6IHN5bnRheCBhbmQgZXhhbXBsZXM%2Cdescription_~SG93IHRvIHVzZSBUT0RBWSBpbiBFeGNlbCBhbmQgR29vZ2xlIFNoZWV0czogZGF5cyB1bnRpbCBhIGRlYWRsaW5lLCBhZ2VzIGFuZCBvdGhlciBkYXRlIG1hdGggZnJvbSB0b2RheS4%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_TODAY()%2Cp_Ii9mdW5jdGlvbnMvdG9kYXki%2Cs_MbS_3SVbtZABuH7o.png"
---

> Index of every page on this site: [llms.txt](https://excelsavvy.com/llms.txt)

# **The TODAY function**

Returns today's date. It updates every time the sheet recalculates.

=

TODAY(

## **How to use TODAY**

TODAY returns today's date from your computer's clock. It takes no arguments, so you always write it with empty parentheses: `**=TODAY()**`. Think of a wall calendar that turns its own page every morning.

That makes it the starting point for any calculation based on today's date. Days left until a deadline: `**=B2-TODAY()**`. How old an invoice is: `**=TODAY()-A2**`. Whether something is overdue: `**=IF(B2<TODAY(),"Overdue","OK")**`. A person's age in whole years: `**=DATEDIF(A2,TODAY(),"y")**`. A contract reminder: `**=IF(B2-TODAY()<=30,"Renew soon","")**`.

Dates are numbers underneath, one step per day, so you can add and subtract days directly: `**=TODAY()+14**` is two weeks from now. For whole months, combine TODAY with EDATE or EOMONTH, as in `**=EOMONTH(TODAY(),0)**` for the last day of this month.

TODAY recalculates whenever the sheet does, so the date moves on each day you open the file. If you need a date that stays put, such as the day an invoice was written, type it in or copy the cell and paste it as a value. When you need the time as well, use NOW instead.

## **Syntax**

```
TODAY()
```

<dl></dl>

## **Examples**

B1=ISNUMBER(TODAY())

|  | A | B |
| --- | --- | --- |
| 1 |  | **TRUE** |

B1=IF(TODAY()>DATE(2020,1,1),"After 2020","Before")

|  | A | B |
| --- | --- | --- |
| 1 |  | **After 2020** |

## **Common TODAY mistakes**

- The date on my invoice changes every day

  TODAY is live, so it shows the date of the day you open the file. For a date that stays fixed, type the date or copy the cell and paste it as a value.
- I get a date in 1900 instead of a number of days

  When you subtract two dates, the cell often keeps a date format. Set the format of the result cell to Number or General, and `**=B2-TODAY()**` shows the days.
- The age calculation is off around birthdays

  Dividing days by 365 ignores leap years, so the result slips. Use `**=DATEDIF(A2,TODAY(),"y")**`, which counts whole years.
- TODAY returns #NAME?

  The parentheses are missing. TODAY needs them even though they stay empty: `**=TODAY()**`, not `**=TODAY**`.

## **Read the guide**

- [**Dates in Excel: how they work and the formulas you need**](https://excelsavvy.com/learn/excel-dates)
- [**Conditional formatting in Excel: highlight cells and rows with rules and formulas**](https://excelsavvy.com/learn/conditional-formatting-excel)

## **Questions**

<details>

<summary>

### How do I insert today's date so it does not change?

</summary>

Press Ctrl+; (semicolon) in a cell to enter the current date as a fixed value. You can also copy a cell with =TODAY() and paste it as a value.

</details>

<details>

<summary>

### How do I get today's date and the time?

</summary>

Use =NOW(). It returns the date and the current time, and like TODAY it recalculates whenever the sheet does.

</details>

<details>

<summary>

### How do I count the days between a date and today?

</summary>

Subtract the date from today: =TODAY()-A2 for the days since A2, or =A2-TODAY() for the days left until A2. Format the result as a number.

</details>

<details>

<summary>

### Why is TODAY not updating?

</summary>

TODAY updates when the sheet recalculates. If calculation is set to manual, press F9 to update it, or switch calculation back to automatic.

</details>

<details>

<summary>

### How do I calculate age from a birth date?

</summary>

Use =DATEDIF(A2,TODAY(),"y") for the age in whole years. Add a second formula with "ym" instead of "y" if you also want the extra months.

</details>

## **Related functions**

- [**DATE**](https://excelsavvy.com/functions/date)
- [**NETWORKDAYS**](https://excelsavvy.com/functions/networkdays)
- [**EOMONTH**](https://excelsavvy.com/functions/eomonth)

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://excelsavvy.com/#identity","@type":"Organization","name":"ExcelSavvy","url":"https://excelsavvy.com/","logo":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/#website","@type":"WebSite","inLanguage":"en-US","name":"ExcelSavvy","url":"https://excelsavvy.com/","alternateName":["Excel Savvy","ExcelSavvy.com","PracticeExcel","Practice Excel Online"],"publisher":{"@id":"https://excelsavvy.com/#identity"},"workTranslation":[{"@id":"https://excelopgaver.dk/#website"},{"@id":"https://excelpraxis.de/#website"}]},{"@id":"https://excelsavvy.com/functions/today#webpage","dateModified":"2026-11-16","description":"How to use TODAY in Excel and Google Sheets: days until a deadline, ages and other date math from today.","name":"TODAY function in Excel: syntax and examples","url":"https://excelsavvy.com/functions/today","@type":["WebPage","FAQPage"],"breadcrumb":{"@id":"https://excelsavvy.com/functions/today#breadcrumb"},"isPartOf":{"@id":"https://excelsavvy.com/#website"},"mainEntity":[{"@id":"https://excelsavvy.com/functions/today#/schema/question/1"},{"@id":"https://excelsavvy.com/functions/today#/schema/question/2"},{"@id":"https://excelsavvy.com/functions/today#/schema/question/3"},{"@id":"https://excelsavvy.com/functions/today#/schema/question/4"},{"@id":"https://excelsavvy.com/functions/today#/schema/question/5"}],"potentialAction":[{"@type":"ReadAction","target":["https://excelsavvy.com/functions/today"]}],"primaryImageOfPage":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/functions/today#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://excelsavvy.com","position":1},{"@type":"ListItem","name":"Excel functions","item":"https://excelsavvy.com/functions","position":2},{"@type":"ListItem","name":"TODAY function in Excel: syntax and examples","position":3}]},{"@id":"https://excelsavvy.com/functions/today#article","dateModified":"2026-11-16","description":"How to use TODAY in Excel and Google Sheets: days until a deadline, ages and other date math from today.","headline":"TODAY function in Excel: syntax and examples","inLanguage":"en-US","thumbnailUrl":"https://excelsavvy.com/_og/d/c_Page%2Ctitle_~VE9EQVkgZnVuY3Rpb24gaW4gRXhjZWw6IHN5bnRheCBhbmQgZXhhbXBsZXM%2Cdescription_~SG93IHRvIHVzZSBUT0RBWSBpbiBFeGNlbCBhbmQgR29vZ2xlIFNoZWV0czogZGF5cyB1bnRpbCBhIGRlYWRsaW5lLCBhZ2VzIGFuZCBvdGhlciBkYXRlIG1hdGggZnJvbSB0b2RheS4%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_TODAY()%2Cp_Ii9mdW5jdGlvbnMvdG9kYXki%2Cs_MbS_3SVbtZABuH7o.png","@type":["Article","TechArticle"],"author":{"@id":"https://excelsavvy.com/#identity"},"image":{"@id":"https://excelsavvy.com/#/schema/image/1"},"isPartOf":{"@id":"https://excelsavvy.com/functions/today#webpage"},"mainEntityOfPage":{"@id":"https://excelsavvy.com/functions/today#webpage"},"publisher":{"@id":"https://excelsavvy.com/#identity"}},{"@id":"https://excelsavvy.com/functions/today#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"How do I insert today's date so it does not change?","acceptedAnswer":{"@type":"Answer","text":"Press Ctrl+; (semicolon) in a cell to enter the current date as a fixed value. You can also copy a cell with =TODAY() and paste it as a value."}},{"@id":"https://excelsavvy.com/functions/today#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"How do I get today's date and the time?","acceptedAnswer":{"@type":"Answer","text":"Use =NOW(). It returns the date and the current time, and like TODAY it recalculates whenever the sheet does."}},{"@id":"https://excelsavvy.com/functions/today#/schema/question/3","@type":"Question","inLanguage":"en-US","name":"How do I count the days between a date and today?","acceptedAnswer":{"@type":"Answer","text":"Subtract the date from today: =TODAY()-A2 for the days since A2, or =A2-TODAY() for the days left until A2. Format the result as a number."}},{"@id":"https://excelsavvy.com/functions/today#/schema/question/4","@type":"Question","inLanguage":"en-US","name":"Why is TODAY not updating?","acceptedAnswer":{"@type":"Answer","text":"TODAY updates when the sheet recalculates. If calculation is set to manual, press F9 to update it, or switch calculation back to automatic."}},{"@id":"https://excelsavvy.com/functions/today#/schema/question/5","@type":"Question","inLanguage":"en-US","name":"How do I calculate age from a birth date?","acceptedAnswer":{"@type":"Answer","text":"Use =DATEDIF(A2,TODAY(),\"y\") for the age in whole years. Add a second formula with \"ym\" instead of \"y\" if you also want the extra months."}},{"@id":"https://excelsavvy.com/#logo","@type":"ImageObject","caption":"ExcelSavvy","contentUrl":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3","inLanguage":"en-US","url":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3"},{"@id":"https://excelsavvy.com/#/schema/image/1","@type":"ImageObject","contentUrl":"https://excelsavvy.com/_og/d/c_Page%2Ctitle_~VE9EQVkgZnVuY3Rpb24gaW4gRXhjZWw6IHN5bnRheCBhbmQgZXhhbXBsZXM%2Cdescription_~SG93IHRvIHVzZSBUT0RBWSBpbiBFeGNlbCBhbmQgR29vZ2xlIFNoZWV0czogZGF5cyB1bnRpbCBhIGRlYWRsaW5lLCBhZ2VzIGFuZCBvdGhlciBkYXRlIG1hdGggZnJvbSB0b2RheS4%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_TODAY()%2Cp_Ii9mdW5jdGlvbnMvdG9kYXki%2Cs_MbS_3SVbtZABuH7o.png","inLanguage":"en-US","url":"https://excelsavvy.com/_og/d/c_Page%2Ctitle_~VE9EQVkgZnVuY3Rpb24gaW4gRXhjZWw6IHN5bnRheCBhbmQgZXhhbXBsZXM%2Cdescription_~SG93IHRvIHVzZSBUT0RBWSBpbiBFeGNlbCBhbmQgR29vZ2xlIFNoZWV0czogZGF5cyB1bnRpbCBhIGRlYWRsaW5lLCBhZ2VzIGFuZCBvdGhlciBkYXRlIG1hdGggZnJvbSB0b2RheS4%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_TODAY()%2Cp_Ii9mdW5jdGlvbnMvdG9kYXki%2Cs_MbS_3SVbtZABuH7o.png"}]}
```

## Sitemap

See the full [sitemap](https://excelsavvy.com/sitemap.md) for all pages.
