To calculate calendar days remaining in Excel, put the deadline in A2 and enter =A2-TODAY() in another cell. The result is the number of days from today to the deadline: a positive number means it is upcoming, zero means it is today, and a negative number means it has passed.
The basic days-remaining formula
Excel stores dates as numbers, so subtracting one date from another returns the number of days between them. The TODAY() function supplies the current date, and updates as the workbook recalculates. For example, if A2 contains November 15, 2026, then on November 3, 2026, =A2-TODAY() returns 12. The formula counts the gap between the dates; it does not count today as a remaining day.
Use this setup when the deadline is in A2 and you want overdue dates to show as negative values. If you want a countdown that never drops below zero, use this instead:
With the deadline date in A2, enter =MAX(0,A2-TODAY()) to return zero for today or any past deadline.
This capped version is useful for a simple countdown display, but it hides how late a task is. For a tracker where overdue work matters, keep the negative result or use a separate status column. Avoid replacing the date with a typed-in number of days: a formula based on the deadline stays current as time passes.
What does days remaining mean?
For calendar days, Excel’s date subtraction gives the difference between two dates, not an inclusive count of every date label on a calendar. If today is Monday and the deadline is Tuesday, the result is one day. If the deadline is today, the result is zero. This is usually the clearest meaning of “days remaining” for due dates, countdowns, and reminders.
Some processes use a different convention. A project may count both the start date and the due date, or a policy may define its own deadline rules. For an inclusive calendar count, with the due date in A2 and today supplied by Excel, enter =A2-TODAY()+1. On the day the deadline arrives, that formula returns 1. Use it only when that inclusive convention is actually intended; otherwise, it can make a deadline appear to have an extra day.
It also helps to distinguish calendar days from business days. Calendar days include weekends and holidays. Business-day counts normally exclude Saturday and Sunday, and can also exclude dates listed as holidays.
Set up the date cells correctly
Enter actual Excel dates in the deadline column rather than text that merely looks like a date. You can type a date in a familiar format and check that Excel recognizes it by changing the cell’s number format or trying a simple subtraction. If Excel treats a value as text, date arithmetic may return an error or an unexpected result. Date interpretation can depend on regional settings, so a date such as 04/05/2026 may mean April 5 or May 4 in different locales.
Keep each deadline in its own row when you have a list. For example, place task names in A2:A20 and due dates in B2:B20, then put a days-remaining formula in C2 and fill it down. In that arrangement, use =B2-TODAY() in C2; each copied row will refer to its own deadline. Consider using clear column headings such as Task, Due date, and Calendar days remaining so readers know what the number represents.
A blank due-date cell needs attention: a plain subtraction formula can treat a blank as zero and display a large negative number. If the deadline is in A2 and the result should stay empty until a date is entered, use =IF(A2="","",A2-TODAY()). This formula checks for an empty deadline first, then calculates the difference only when a date is present.
Calculate working days instead
For deadlines that are measured in weekdays, use Excel’s NETWORKDAYS function. It counts workdays between two dates, including the start and end dates when those dates are weekdays. Since a “remaining” count often excludes today but includes a weekday deadline, start the count tomorrow. With the deadline in A2, enter =MAX(0,NETWORKDAYS(TODAY()+1,A2)). The MAX keeps the result at zero rather than negative when the deadline is today or has passed.
For example, on Tuesday, November 3, 2026, if A2 contains Tuesday, November 10, 2026, the formula counts Wednesday through Friday and Monday through Tuesday: five working days. It does not count Saturday or Sunday. If the deadline itself falls on a weekend, it is not counted as a working day, although the formula still returns workdays before it.
This differs from counting the number of complete 24-hour periods or the number of weekdays touched by an interval. If a workplace defines a deadline as due at the start of the day, or counts the current day as available working time, adjust the start-date convention to match that rule. The formula cannot determine a company’s or institution’s deadline policy.
Exclude holidays and use custom weekends
To exclude holidays, list the holiday dates in a range such as H2:H10 and pass that range to NETWORKDAYS. With the deadline in A2 and holiday dates in H2:H10, use =MAX(0,NETWORKDAYS(TODAY()+1,A2,$H$2:$H$10)). The dollar signs keep the holiday range fixed if you copy the formula down a column. Make sure the holiday entries are real dates, not text, and update the list when the calendar changes.
Some schedules do not use Saturday and Sunday as the weekend. For a different weekend pattern, use NETWORKDAYS.INTL. With the deadline in A2, holiday dates in H2:H10, and Saturday-Sunday still designated as the weekend, enter =MAX(0,NETWORKDAYS.INTL(TODAY()+1,A2,1,$H$2:$H$10)). The weekend code 1 specifies Saturday and Sunday. Other numeric codes and a seven-character weekend pattern can define other rest days; consult Excel’s function help when setting a nonstandard pattern, because the order of the days matters.
Holiday handling is only as accurate as the list. A fixed holiday list may not cover local observances, substitute days, or a business’s own closure dates. For recurring reports, store the holiday dates in a clearly labelled range and assign that range a name if doing so makes formulas easier to read. Keep the list in the workbook so another person can see which dates were excluded.
Display the result clearly
Keep the result numeric if you may sort, chart, compare, or use it in other calculations. A formula result that has accidentally been formatted as a date can look like a date in 1900 rather than a small day count. Select the result cells and choose Home > Number Format, then select General or Number. If you prefer a label such as “12 days remaining,” use a neighboring text or status column rather than turning the calculation itself into text.
For a quick visual scan, conditional formatting can highlight short countdowns. Select the numeric result range and choose Home > Conditional Formatting > Highlight Cells Rules > Less Than, then set an appropriate threshold, such as 8. Consider applying a separate rule for values below zero so overdue items are visually distinct. A threshold is a display choice, not a change to how the underlying date calculation works.
If the displayed value does not change after midnight, Excel may not have recalculated the workbook. Check Formulas > Calculation Options and choose Automatic if that suits the workbook. TODAY() is a volatile function: it updates when Excel recalculates, not as a live clock that refreshes continuously while the file remains untouched.
Common mistakes and checks
- Counting the due date twice: Date subtraction returns the gap between dates. Add 1 only if an inclusive count is required by the rules you are following.
- Ignoring overdue values: A negative result is useful information. Use a capped formula only when zero is more useful than knowing how late the deadline is.
- Using the wrong date convention: Confirm that Excel interpreted the entered month and day as intended, particularly when a workbook is shared across locales.
- Including today in a business-day count by accident: Starting
NETWORKDAYSatTODAY()+1excludes today. Starting atTODAY()can count today if it is a weekday. - Forgetting holidays: The default business-day functions exclude weekends, not public holidays. Supply a holiday range if those dates should be removed.
- Leaving blanks unhandled: Add an empty-cell check when a row may not yet have a deadline, so a blank is not mistaken for a date.
For diagnosis, check the deadline cell’s value and the formula bar, then test the subtraction in a spare cell. If the formula returns an error, confirm that the cell contains a valid date and that the formula’s parentheses and cell references are intact. If the number is off by one, first decide whether the intended count is exclusive or inclusive; that convention is a more common explanation than a broken date calculation.
Choose the right formula for the task
Use =A2-TODAY() for an ordinary calendar-day countdown where overdue values should remain negative. Choose =MAX(0,A2-TODAY()) for a nonnegative countdown display. Use NETWORKDAYS when the schedule follows a Monday-to-Friday workweek, adding a holiday range when needed. Choose NETWORKDAYS.INTL when the weekend pattern differs from Saturday and Sunday.
For a project list, a useful setup is one column for the deadline, one for days remaining, and one for a human-readable status such as Not started, In progress, or Complete. The countdown answers how far away the date is; it cannot tell whether work is finished, whether a deadline has been approved, or whether a task is still relevant. Separating those facts makes the sheet more informative and avoids using a date calculation as a substitute for project status.
Frequently Asked Questions
How do I calculate days remaining from today in Excel?
Put the deadline in a cell such as A2 and enter =A2-TODAY() in another cell. A positive result is the calendar-day difference, zero means the deadline is today, and a negative result means it has passed.
How do I make Excel show zero instead of a negative number?
Use =MAX(0,A2-TODAY()) when the deadline is in A2. This prevents the countdown from going below zero, but it no longer shows how many days overdue the item is.
Does Excel count today as a day remaining?
No. Date subtraction returns zero when the deadline is today. Add 1 to the difference only if you intentionally need an inclusive count that treats today as one of the counted dates.
How do I count business days remaining, excluding holidays?
Use NETWORKDAYS with a start date of tomorrow, the deadline, and a range containing holiday dates. For example, if the deadline is in A2 and holidays are in H2:H10, use =MAX(0,NETWORKDAYS(TODAY()+1,A2,$H$2:$H$10)).
Why does my days-remaining formula show a date instead of a number?
The result cell may be formatted as a date. Select it and change Home > Number Format to General or Number. The underlying subtraction can be correct even when the displayed format is not appropriate for a day count.
Related
- Python Pandas Excel to Dictionary: Practical Guide
- Python pandas Excel Formatting: A Practical Guide to Styles
- Correlation Table in Excel: Create and Read One
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Named Range in a Formula: How to Use It CorrectlyIn Excel, use a named range in a formula by typing its name where you would normally put…
- Percentage Difference in Excel: Formula and ExamplesTo find percentage difference in Excel, divide the absolute difference between two values by their average, then format…
- Excel MID Function From the Right: Formulas That WorkNo: Excel’s MID function always counts characters from left to right. To take a fixed number of characters…
- Excel Sum Range Based on Cell Value: SUMIF and MoreWith the values to test in A2:A7, amounts to add in B2:B7, and the requested category in D2,…
- Vending Machine Inventory Spreadsheet: Setup and FormulasA vending machine inventory spreadsheet tracks what is loaded, what remains, what sold, and what needs restocking. Start…
- Remove Spaces at the End of Text in Excel with TRIMTo remove ordinary spaces at the end of text in Excel, put =TRIM(A2) in a helper column if…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.