Spreadsheet formulas explained, side by side

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

AppSupportSyntax & notes
Excel✔ Built inTODAY()
NOW() returns the date and the current time.
Google Sheets✔ Built inTODAY()
Airtable✔ Built inTODAY()
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 intoday()
Add time with dateAdd(today(), n, "days"); now() includes the time.
Try TODAY with your own values
Negative numbers go back in time
Result (as Excel & Google Sheets return it)
Sat, Dec 19, 2026 2026-12-19 ยท stored as serial number 46375 in Excel and Sheets
Your formula, ready to paste
Excel=TODAY() + 30 open excel.new ↗
Google Sheets=TODAY() + 30 open sheets.new ↗
AirtableDATEADD(TODAY(), 30, 'days')
NotiondateAdd(today(), 30, "days")

The result uses your computer's date, so it changes tomorrow — just like the real function.

Arguments

ArgumentWhat it means
(none)TODAY takes no arguments, but the parentheses are required.

Examples

FormulaResultWhyCopy
=TODAY()Today's dateFormat the cell as a date if you see a number.
=TODAY() + 30The date 30 days from nowDates are day counts, so plain addition adds days.
=A2 - TODAY()Days until the date in A2Negative once the date has passed. Format the result as a number.
=DATEDIF(A2, TODAY(), "Y")Age in whole yearsA2 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 @Today mention.
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.

Part of the Date & Time functions. Results in the tester follow Excel and Google Sheets behaviour; always double-check important work in your own file.