Knowledge base / Excel
TODAY in Excel: current dates, deadlines and refreshes
Calculate days remaining and distinguish overdue, current and future deadlines. I also explain why TODAY does not record the import date.

You open last month’s report and its “last updated” field shows today. The data is still old. Putting TODAY() where a refresh date should be recorded makes this surprisingly easy.
I keep those concepts separate. TODAY supports calculations relative to the current day. An event or import date needs an independent record. This entry shows deadline calculations and explains how to avoid a moving reference date in a historical report.
What TODAY returns
=TODAY()
The Polish name is DZIŚ. The function takes no arguments, but the parentheses remain necessary. It returns the current date as an Excel serial number, without a time component. Cell formatting controls its appearance. See the Microsoft reference.
In desktop Excel the date depends on the system clock. The result updates through recalculation, so an open workbook is not a continuously running clock. If the value does not change when expected, inspect calculation options, including automatic calculation.
I use English names and commas; separators depend on regional settings. Microsoft lists TODAY for Microsoft 365 and Excel releases from 2016 through 2024. These examples do not require dynamic array features.
Days to a deadline: synthetic data
To keep the example reproducible after today, enter the reference date =DATE(2026,11,5) in E1. Put headers in A1:B1 and these synthetic deadlines in rows 2:4. Column B contains real Excel dates without times.
| Row | A: Task | B: Deadline | Days remaining |
|---|---|---|---|
| 2 | First | 2026-11-04 | -1 |
| 3 | Second | 2026-11-05 | 0 |
| 4 | Third | 2026-11-08 | 3 |
In C2, enter and fill down:
=B2-$E$1
A negative result means the deadline precedes the reference date, zero means the same day, and a positive result gives the remaining days. Format column C as a number. A date format can make a difference in days look like an unexpected date near the beginning of Excel’s calendar.
In a live dashboard I can change E1 to =TODAY(). Every calculation then uses one visible reference date. Reproducing a historical state requires retaining that date as a fixed value. Copying a workbook containing the formula leaves the reference dynamic.
Include the “today” case
For dates without times, I use:
=IF(B2="","No deadline",IF(B2<$E$1,"Overdue",IF(B2=$E$1,"Today","Not yet due")))
The three rows receive “Overdue”, “Today” and “Not yet due”. The blank check prevents an absent deadline from receiving an ordinary date status. A condition meaning “not earlier than today” includes today itself, so calling all of those dates future would be misleading.
For timestamps, decide whether the report classifies calendar days or exact moments. TODAY identifies the beginning of the current day. A “today” test for timestamps needs an interval from that boundary to the beginning of the next day, rather than equality alone.

A current date is different from a recorded date
TODAY does not record the last cell change, import or approval. If the source has not refreshed for a week, the formula can still show the current day. Labeling it as the data refresh date gives the reader false confidence about freshness.
You can enter a fixed date as a value; in desktop Excel, Ctrl+; inserts the current date in that form. Microsoft distinguishes static values from dynamic formulas. For an automated import, a refresh timestamp should come from the process that actually completed it.
When archiving a report I preserve both the reference date and the source coverage. A report calculated today from data ending in October describes a different situation from a dashboard containing data through today. One date field should not stand in for both pieces of information.
Dates in sentences and the NOW function
If I only need a displayed date, I keep it in a separately formatted date cell. Concatenating text with TODAY without controlled formatting can expose the underlying serial number.
With English date format codes, I can write:
="Reference date: "&TEXT(TODAY(),"yyyy-mm-dd")
The result is text. Calculations should refer to the original date rather than the label. Format codes depend on language; copy the appropriate code from the Format Cells dialog if needed. Microsoft explains this in the TEXT reference.
NOW() returns both date and time. It also changes through recalculation rather than continuously, as the documentation emphasizes. It does not automatically turn a workbook into an event log.
Age requires complete years
YEAR(TODAY())-YEAR(A2) compares year numbers. Before a birthday, it can overstate age by one. For complete years between the date of birth in A2 and the reference date in E1, the relevant calculation is:
=DATEDIF(A2,$E$1,"Y")
The Polish function is DATA.RÓŻNICA. Microsoft defines Y as complete years and documents an error when the start date is later than the end date. It also describes limitations, particularly for the MD unit, which this example does not use.
Exercise with two reference dates
Change E1 from November 5 to November 6, 2026. The day differences should become -2, -1 and 2, and the second task should become overdue. Then restore November 5. This shows how the reference date alone changes the report without editing any deadline.
Continue with YEAR and IF. For your own workbook, decide whether you need the current day, a historical reporting date or the time an import completed before selecting a function.
Key takeaways
Does TODAY record the data refresh date?
No. It returns the current date through recalculation. A refresh timestamp must be recorded by the import process or as an independent value.
Why does my day difference look like a date?
The result cell has a date format. Use a numerical format for the day count while keeping the inputs formatted as dates.
Does TODAY include a time?
No. NOW returns date and time, but also updates through calculation and does not provide a fixed event record.
AI was used in an automated way while working on this article. If you want to learn how to do it too, check out this project.
