TODAY Function in Excel, Google Sheets, Airtable & Notion
TODAY returns the current date with no time part. It recalculates on its own, so it is the building block for ages, deadlines and “days overdue” columns.
Syntax in each app
| App | Support | Syntax & notes |
|---|---|---|
| Excel | ✔ Built in | TODAY()NOW() returns the date and the current time. |
| Google Sheets | ✔ Built in | TODAY() |
| Airtable | ✔ Built in | TODAY()Add time with DATEADD(TODAY(), n, 'days'). Airtable refreshes TODAY() and NOW() periodically, not continuously, and calculates the date in GMT, so near midnight it can differ from your local date. |
| Notion | ✔ Built in | today()Add time with dateAdd(today(), n, "days"); now() includes the time. |
| Excel | =TODAY() + 30 | open excel.new ↗ |
|---|---|---|
| Google Sheets | =TODAY() + 30 | open sheets.new ↗ |
| Airtable | DATEADD(TODAY(), 30, 'days') | |
| Notion | dateAdd(today(), 30, "days") |
Excel & Sheets use cell ranges. Paste this sample data into cell A1 of a blank sheet, then paste the formula into any empty cell.
The result uses your computer's date, so it changes tomorrow — just like the real function.
Arguments
| Argument | What it means |
|---|---|
(none) | TODAY takes no arguments, but the parentheses are required. |
Examples
| Formula | Result | Why | Copy |
|---|---|---|---|
=TODAY() | Today's date | Format the cell as a date if you see a number. | |
=TODAY() + 30 | The date 30 days from now | Dates are day counts, so plain addition adds days. | |
=A2 - TODAY() | Days until the date in A2 | Negative once the date has passed. Format the result as a number. | |
=DATEDIF(A2, TODAY(), "Y") | Age in whole years | A2 holds the birth date; see DATEDIF. |
Examples use Excel / Google Sheets syntax unless noted.
How TODAY works
TODAY is volatile: Excel and Google Sheets recalculate it whenever the sheet changes or is opened, so a value that said 15 March yesterday says 16 March today. That is exactly what you want for “days overdue” or age, but not for recording when something happened. To stamp a fixed date press Ctrl+; in Excel or Google Sheets, which types today's date as a value. Google Sheets also lets you choose under File → Settings → Calculation whether NOW/TODAY update on change, every minute or every hour.
Because a date is a day count, =TODAY() + 7 is a week from now and =A2 - TODAY() is the days remaining. For months use EDATE: =EDATE(TODAY(), 3). In Airtable and Notion you cannot add a number to a date with +; use DATEADD / dateAdd instead, and DATETIME_DIFF / dateBetween to get the gap between two dates.
In Airtable, TODAY() is not live to the second: formulas that use it refresh when the base is open and roughly every few hours otherwise, and the date is calculated in GMT, so near midnight it can be a day off from your local date.
Frequently Asked Questions
- How do I insert today's date so it never changes?
- Press Ctrl+; (Excel and Google Sheets) to type it as a fixed value. In Airtable use a Created time field; in Notion a Created time property or the
@Todaymention. - What is the difference between TODAY and NOW?
- TODAY is the date at midnight (a whole serial number). NOW includes the current time as a fraction of a day.