To calculate days left in Excel, put the deadline in A2 and enter =A2-TODAY() in another cell. The result is the number of calendar days from today to that date: a future deadline gives a positive number, today gives 0, and a past date gives a negative number.
The basic days-left formula
For the basic setup, enter a real Excel date in A2 and place the formula in B2: =A2-TODAY(). For example, if A2 contains November 10, 2026, and today is November 3, 2026, B2 returns 7. The formula updates as the current date changes, so it can serve as a live countdown without manual edits.
Excel stores dates as serial numbers, so subtracting one date from another returns the number of days between them. TODAY() supplies the current date, while A2 supplies the deadline. The formula counts the difference between the dates; it does not count the current date as an additional full day. That is why a deadline that is today returns 0 rather than 1.
Use a cell reference such as A2 rather than typing the deadline directly into the formula. Then you can change the deadline without rewriting the calculation, and you can copy the formula down a column for a list of tasks.
How TODAY updates the result
TODAY() is a date function that returns the current date based on the computer’s date. It does not include the current time. Excel recalculates it when the workbook recalculates, such as when you reopen the workbook or make a change that triggers calculation. It is a volatile function, meaning Excel may recalculate it more often than a formula based only on fixed values.
This behavior is useful for a live deadline tracker, but it matters when you need an unchanging record of how many days remained on a particular day. A formula using TODAY() is designed to change over time. For a historical snapshot, copy the result and use Paste Special > Values, or record the date and result as fixed values in a separate log. Do not replace TODAY() with a fixed date unless you specifically want the countdown to stop updating.
If the value does not appear to update, check that calculation is set to automatic. In Excel for Microsoft 365 on Windows, open Formulas > Calculation Options > Automatic. Excel for Mac has the corresponding Calculation Options control on the Formulas tab; wording and placement can vary slightly by release. Reopening the workbook or forcing a recalculation can also refresh the displayed result.
Calendar days, counting today, and examples
The basic subtraction counts the date difference, which is usually what people mean by days remaining. A deadline tomorrow returns 1, and a deadline today returns 0. If a process instead treats today as day one, add one to the result. That is a different counting convention, not a correction to Excel’s date subtraction.
With the deadline in A2, use =A2-TODAY()+1 when the intended count includes both today and the deadline date. If A2 is November 10, 2026, and today is November 3, 2026, the formula returns 8: November 3 through November 10 inclusive. Confirm the convention with the person or process using the number, because inclusive counting can produce an off-by-one difference in schedules and instructions.
Here are common interpretations of the standard formula:
- Future date: A positive result is the number of calendar days until the deadline.
- Today’s date: The result is 0 because no whole date boundary remains.
- Past date: A negative result shows how many days ago the deadline fell.
- Weekend deadline: The basic formula still counts Saturday and Sunday, just like any other calendar days.
For a visual countdown, format the result as a number with zero decimal places. A date subtraction ordinarily returns an integer when both cells contain dates without times. Avoid formatting the result cell as a date: Excel may then display the serial number as a calendar date rather than as a day count.
Count workdays instead of calendar days
If weekends should not count, use NETWORKDAYS rather than simple subtraction. With the deadline in A2, enter =MAX(0,NETWORKDAYS(TODAY()+1,A2)) to count weekdays strictly after today and through the deadline, returning 0 instead of a negative value for a past deadline. For a deadline on a weekday, the result includes that deadline day. If the deadline is Saturday or Sunday, it does not count as a workday.
NETWORKDAYS treats Saturday and Sunday as weekends by default. If you maintain holiday dates in D2:D10, use =MAX(0,NETWORKDAYS(TODAY()+1,A2,D2:D10)) to exclude those dates as well. The dates in the holiday range must be real Excel dates, not text that merely looks like dates. Leave the holiday range empty or omit the optional argument if you have no holiday list.
Starting the calculation at tomorrow is intentional: NETWORKDAYS normally includes both endpoints when they are workdays, but a days-left count generally excludes today. If you want to count today as a remaining workday when it is a weekday, use a different start-date convention and check the result against your organization’s rule. NETWORKDAYS is suitable for a Monday-to-Friday schedule; for a nonstandard weekend, NETWORKDAYS.INTL lets you specify which days are weekends.
Handle past deadlines and blank cells
A negative result can be informative because it shows how overdue a deadline is. For a task list where negative values are not useful, use MAX to set a floor of zero. With the deadline in A2, enter =MAX(0,A2-TODAY()). A future date still returns its days remaining, while a date today or earlier returns 0.
Blank deadline cells need special treatment. Excel can interpret a blank reference in date arithmetic as zero, which may make the result look like a very large negative number. With the deadline in A2, use =IF(A2="","",A2-TODAY()) to leave the result blank until a date is entered. This is useful in a copied-down task table, where many rows may not have deadlines yet.
To display a label instead of an empty result, use =IF(A2="","No deadline",A2-TODAY()). The output column will then contain text for blank rows and numbers for rows with dates. Keep that in mind if you later sort, chart, or perform calculations on the output, since text labels do not behave like numeric day counts.
Dates that include a time
Excel dates can include a time as a decimal fraction. For example, a value representing a date at noon has a fractional part. If A2 contains a deadline timestamp rather than a date-only value, =A2-TODAY() can return a decimal. Applying a number format with zero decimal places may round the displayed result, which can make the shown number differ from a strict count of calendar date boundaries.
To count whole calendar dates and ignore the time component, with a timestamp in A2 use =INT(A2)-TODAY(). INT removes the fractional part of the date-time serial, leaving the date portion. If the actual requirement is hours or minutes until an exact appointment time, this is not the right measure; subtract the current date and time with NOW() and choose an appropriate number format instead. A countdown to a date and a countdown to a precise appointment are different calculations.
Common errors and ways to check the result
If Excel returns #VALUE!, the deadline may be text rather than a recognized date. Select A2 and check whether Excel treats it as a date: changing its number format to General should reveal a serial number for a valid date. If the contents remain text, re-enter the date in a format recognized by your regional settings or convert the source data to real dates before subtracting.
Regional date conventions can create ambiguity. A value such as 04/05/2026 may mean April 5 or May 4 depending on the locale. Use an unambiguous date entry method, or verify the interpreted date by applying a long date format. In a shared workbook, check that users’ settings do not lead to different interpretations of imported text dates.
When a result seems off by one, check these points before changing the formula:
- Does the rule count today, or only the full days after today?
- Should the deadline date itself count as a remaining workday?
- Is the value in the deadline cell a date, a date-time, or text?
- Is the result cell formatted as a number rather than a date?
- Are weekends and holidays meant to be excluded?
Also verify that the computer’s date is correct. Since TODAY() depends on the system date, a wrong system clock can make every countdown in the workbook wrong even when the formulas and cell values are sound.
Choosing the right formula
Use ordinary subtraction for most deadlines measured in calendar days. It is simple, transparent, and makes past-due amounts visible. Use MAX when the display should never fall below zero, IF when rows may have no deadline yet, and NETWORKDAYS when the requirement is a count of working days. If time of day is irrelevant but timestamps are present, use INT to remove the time portion.
These formulas answer different questions, so choose according to the underlying rule rather than the display you prefer. For example, counting calendar days to a shipping date is not the same as counting business days to a processing deadline. Likewise, an inclusive count is not interchangeable with a date difference. A short note in the worksheet explaining the convention can prevent colleagues from treating two different counts as contradictory.
Frequently Asked Questions
What is the simplest formula for days left in Excel?
Put the due date in A2 and enter =A2-TODAY() in the result cell. It returns positive days for a future date, zero for today, and negative days for a past date.
How do I stop the days-left result from going below zero?
With the due date in A2, use =MAX(0,A2-TODAY()). This keeps completed or overdue deadlines at zero rather than showing a negative count.
How can I calculate days left excluding weekends?
With a deadline in A2, use =MAX(0,NETWORKDAYS(TODAY()+1,A2)) to count weekdays after today through the deadline. Add a holiday-date range as NETWORKDAYS’ optional third argument if holidays should be excluded.
Why does my formula show a negative number?
The date in the deadline cell is earlier than today. The negative value is the number of calendar days overdue. Use MAX to display zero instead, or keep the negative value if overdue status is useful.
Why does Excel show a date instead of a number of days?
The result cell is likely formatted as a date. Change its number format to General or Number, and use zero decimal places for a whole-day count. Date subtraction returns a numeric difference, not a date label.
Does the formula count today as one day?
No. The standard subtraction returns 0 when the deadline is today and 1 when it is tomorrow. If your counting rule includes today, add 1, while recognizing that this changes the convention to an inclusive count.
Related
- Excel PivotTable Calculated Fields: How to Create One
- Degree Symbol in Excel: Add It to a Cell and Format Values
- Dynamic Named Range in Excel: Create One That Expands
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Sequence Excel Without Duplicates: Formulas & TipsTo create a duplicate-free sequence in Excel for Microsoft 365, enter =SEQUENCE(10) in an empty cell; it spills…
- Generate Row Numbers by Group in Excel with FormulasTo generate a row number that restarts for each group in Excel, put group names in A2:A100 and…
- Excel Named Ranges in Formulas: How to Use ThemYes. Excel lets you use a named range in a formula just like a cell reference: if the…
- Excel Loan Payment Formula: How to Use PMTFor a fixed-rate loan with monthly payments, Excel’s PMT function calculates the regular payment. If B1 contains the…
- Power BI DAX Concatenate: Examples and UsageIn Power BI DAX, join two text values with the ampersand operator (&) or the CONCATENATE function; to…
- Excel MID Function: Extract Text from a Cell’s MiddleTo extract characters from the middle of a cell in Excel, use the MID function, which takes a…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.