What it does
=TODAY() is written with empty brackets and returns the date only, with no time. Because Excel stores dates as numbers, the result can be added to, subtracted from and compared with other dates: =B2-TODAY() gives the days left until a due date.
TODAY is volatile: it recalculates every time the file opens and whenever the sheet changes. That makes it unsuitable for recording the day an invoice was issued, because the cell changes the next day. If you need a fixed date, type it in, or copy the formula and use Paste Values.
If you also need the time, use NOW. TODAY is often combined with DATEDIF for completed years and months, NETWORKDAYS for working days and EDATE for a date a few months ahead.
Syntax
=TODAY()=BUGÜN()Arguments in square brackets are optional. English Excel separates arguments with commas (,) and uses a dot for decimals; Turkish Excel uses semicolons (;) and a decimal comma. Excel shows function names in its own language when it opens the file.
Arguments
| Argument | Required | Description |
|---|
Examples
1Days to the due date and overdue status
Column C subtracts today from the due date; the result is the number of days left and turns negative for an overdue invoice. Column D writes a status from that number. The results on this page are based on 5 November 2026.
=B2-TODAY()| A | B | C | D | |
|---|---|---|---|---|
| 1 | Invoice | Due Date | Days Left | Status |
| 2 | F-2041 | 20-Nov-2026 | 15 | Pending |
| 3 | F-2043 | 5-Nov-2026 | 0 | Due today |
| 4 | F-2045 | 28-Oct-2026 | -8 | Overdue |
| 5 | F-2047 | 15-Dec-2026 | 40 | Pending |
- C2 (filled down to C5)
=B2-TODAY() - D2 (filled down to D5)
=IF(C2<0,"Overdue",IF(C2=0,"Due today","Pending"))
F-2041 has 15 days to go. For the overdue F-2045 the result is negative (-8) and the status is Overdue; F-2043, due today, shows Due today. Open the file tomorrow and every number drops by one.
Results are as of 5 November 2026; on that day we recalculated them in real Excel (Microsoft 365, 16.0) and they matched.
2Years of service up to today
DATEDIF counts the completed years from the start date to today. The results are based on 5 November 2026 and recalculate each day the file is opened.
=DATEDIF(B2,TODAY(),"y")| A | B | C | |
|---|---|---|---|
| 1 | Employee | Start Date | Service (Years) |
| 2 | Emma | 2-Mar-2015 | 11 |
| 3 | Liam | 5-Nov-2019 | 7 |
| 4 | Olivia | 6-Nov-2021 | 4 |
| 5 | Noah | 17-Jun-2024 | 2 |
- C2 (filled down to C5)
=DATEDIF(B2,TODAY(),"y")
Today is Liam's work anniversary, so he reaches a full 7 years. Olivia started one day later and is still at 4; tomorrow she moves up a year too.
Results are as of 5 November 2026; on that day we recalculated them in real Excel (Microsoft 365, 16.0) and they matched.
Common errors and fixes
- Difference shown as a date
Cause: The result of
=B2-TODAY()appears as a date such as 15/01/1900 because the cell picked up a date format.Fix: Set the cell format to General or Number; the result is a number of days.
- Record date keeps changing
Cause: An invoice date was entered with TODAY, so it changed when the file was opened the next day.
Fix: Type record dates in by hand, or fix the formula with Paste Values.
- #VALUE!
Cause: The date column holds dates stored as text that Excel cannot read as dates, so they cannot be subtracted from TODAY.
Fix: Convert them to real dates; to build them from parts, use DATE.
Good to know
- To see delays as positive numbers, use
=TODAY()-B2; to show only overdue days, use=MAX(0,TODAY()-B2)(MAX). - If Calculation Options are set to Manual, TODAY does not refresh by itself; press F9 to recalculate.
In Nexell
Get Nexell to do it from a sentence
Add a column to the invoice list showing how many days are left until each due date, and a status column that says "Overdue" when the due date has passed
Convert to tableBring your invoice list into the tool and type this. Nexell adds both columns with real Excel formulas and shows them in the preview; in the downloaded file, the days left update by themselves every day.
Nexell uses AI to understand the request and builds the result with real Excel formulas; the formula may differ from the example on this page. You see a preview first and nothing changes until you press Apply; formulas stay live in the downloaded .xlsx file.
Free account · no card needed · 30 credits a month
Frequently asked questions
How do I enter today's date so that it does not change?
Type the date straight into the cell, or enter =TODAY(), then copy the cell and use Paste Values. A cell that keeps the TODAY formula changes every day.
How do I calculate age in Excel?
With the date of birth in B2, =DATEDIF(B2,TODAY(),"y") gives the age in completed years (DATEDIF). For age with decimals, use =YEARFRAC(B2,TODAY(),1).