Days Left in Excel: Calculate Workdays and Calendar Days

Formulas & functions · Updated November 22, 2026

To calculate days left in Excel, subtract today’s date from the deadline: if the deadline is in A2, enter =A2-TODAY() in another cell. For a deadline of November 10, 2026, the result is 7 on November 3, 2026; the number updates as the current date changes.

How the days-left formula works

With the deadline stored as a real Excel date in A2, enter =A2-TODAY() in B2. The result is the number of calendar days between today and the date in A2. Excel stores dates as serial numbers, so subtracting one date from another gives the number of days between them. The formula counts every calendar day, including Saturdays, Sundays, and holidays.

The example is dynamic: TODAY() returns the current date according to the computer’s system clock, so the result normally changes when the workbook recalculates on a later day. If A2 contains November 10, 2026, the result is 7 on November 3, 6 on November 4, and 0 on November 10. If the deadline has already passed, the result is negative. A result of -2 means the date was two days ago.

In Excel for Microsoft 365 on Windows, enter the formula in a cell such as B2 and press Enter. If you have a list of deadlines, copy the formula down the column using the fill handle at the lower-right corner of the selected cell. Excel adjusts A2 to A3, A4, and so on for each row. On a Mac, the formula works the same way; the interface and some keyboard shortcuts differ, but no special Mac formula is needed. Excel for the web also supports the formula.

Counting the deadline day or avoiding negative results

There is a small but important counting convention to decide. The standard subtraction formula returns zero on the deadline itself because no full days remain until that date. This is usually the clearest answer to “how many days until my deadline?” If you want to count today as one of the days in a period that includes the deadline, add one instead.

With the deadline in A2, enter =A2-TODAY()+1 in B2 to count both today and the deadline date. For a deadline seven days away, this returns 8, representing the seven intervening date changes plus today. Be explicit about this convention when sharing a tracker: inclusive counts can be useful for planning, but they are not the same as the number of full days remaining.

To show zero instead of a negative number after a deadline passes, use =MAX(0,A2-TODAY()) in B2, assuming A2 holds the deadline. MAX returns whichever is greater: the calculated number of days or zero. This is useful for dashboards where negative values are distracting. It also means the formula no longer tells you how late an overdue item is, so consider a separate status or overdue-days column if that information matters.

Counting workdays instead of calendar days

For a business deadline, you may care about weekdays rather than every date. NETWORKDAYS counts Monday through Friday by default and can exclude a list of holidays. To count weekdays after today through the deadline, put the deadline in A2 and enter =MAX(0,NETWORKDAYS(TODAY()+1,A2)) in B2. The +1 starts the count tomorrow, so today is not counted as a remaining workday. MAX prevents a negative result when the date is past.

For example, if today is Tuesday, November 3, 2026, and A2 is Tuesday, November 10, the weekdays after today through the deadline are November 4, 5, 6, 9, and 10. The formula returns 5. Saturdays and Sundays are excluded; the deadline itself is included if it falls on a weekday. A deadline that lands on a weekend does not add a weekend day to the count.

To exclude holidays as well, list actual holiday dates in F2:F10. With the deadline still in A2, enter =MAX(0,NETWORKDAYS(TODAY()+1,A2,$F$2:$F$10)) in B2. The dollar signs keep the holiday range fixed when you copy the formula down. Replace F2:F10 with the range containing your organization’s holiday dates; blank cells in the range are ignored.

NETWORKDAYS assumes Saturday and Sunday are nonworking days. For a different weekend pattern, such as Friday and Saturday, use NETWORKDAYS.INTL, which lets you specify weekend days. Check the function’s weekend argument against the pattern you need before relying on its count. Work schedules vary, so a basic Monday-to-Friday calculation may not match shift work, local public holidays, or an employer’s calendar.

Setting up a reusable deadline tracker

A simple layout makes the calculation easier to audit and maintain. Use one column for the task, one for the deadline, and one for the days remaining. For example, A1 could be Task, B1 Deadline, and C1 Days left. Enter real Excel dates in B2:B20, then put the formula in C2 and copy it down. Keeping the input date separate from the calculated result makes it clear which value a person should edit.

With deadlines in B2:B20, enter =B2-TODAY() in C2, then fill the formula down through C20. Each row will calculate against its own date. For a version that leaves the result blank when the deadline cell is empty, enter =IF(B2="","",B2-TODAY()) in C2 before copying it down. This avoids a misleading number in rows that have no deadline. A blank check is useful in a growing task list, where future rows may not yet be filled in.

For a tracker that should flag dates in the past, keep the raw day count and add a separate status column, or use Home > Conditional Formatting to highlight negative numbers. That preserves the useful overdue amount while making late items easier to spot. If you turn the range into an Excel table with Insert > Table, formulas can fill down automatically as you add rows, and the column headings make the data easier to filter.

Formatting the result and checking date values

A days-left result should normally be formatted as a number, not as a date. If Excel displays an unexpected calendar date after you enter the subtraction formula, select the result cell and choose Home > Number Format > General or Number. Excel is showing the numeric result using a date format; the underlying subtraction can still be correct. A zero-decimal number format is often easiest to read.

The deadline cell must contain a date Excel recognizes, not text that only looks like a date. A quick clue is alignment: dates and numbers are often right-aligned by default, while text is often left-aligned, although custom formatting can change this. If subtraction returns #VALUE!, check for text dates, stray spaces, or a value imported in an unexpected format. Re-entering the date in a recognized format or converting the source data may solve the issue.

Date interpretation can depend on regional settings. For example, 04/05/2026 can mean April 5 or May 4 depending on the date convention. To avoid ambiguity in a workbook shared across regions, enter dates using an unambiguous date picker or a clearly understood format, and verify the displayed date after entry. Formatting a cell changes how a valid date is displayed; it does not reliably convert text into a real date by itself.

Common mistakes and what to expect

  • Using the wrong reference: The formula must point to the cell containing the deadline, not the cell containing a task name or status.
  • Expecting the value to update every second: TODAY updates during workbook recalculation, not as a live countdown timer. Press F9 in Windows to recalculate formulas when needed; on many Mac keyboards, use Fn+F9 or the equivalent function-key setting.
  • Confusing a zero with an error: Zero means the deadline is today under the standard formula. A negative value means it has passed.
  • Counting weekends by mistake: Subtracting dates counts calendar days. Use NETWORKDAYS when the question is specifically about weekdays.
  • Adding one without defining the count: The inclusive formula counts today and the deadline. It is not a correction to the ordinary formula; it answers a different counting question.

For a workbook that must preserve a fixed snapshot, remember that TODAY is volatile and changes with the current date. Copy the calculated results and use Paste Special > Values if you need to preserve the numbers as a record, or enter a fixed reference date in a separate cell and calculate from that date. A fixed reference is also useful for testing a schedule because the result will not shift the next time the workbook opens.

Choosing the right calculation

Use a simple date subtraction when you want calendar days until a deadline and want overdue items to appear as negative numbers. Use the MAX version when the display should stop at zero after the deadline. Choose the inclusive version only when the count should include both today and the deadline date. For work schedules, use NETWORKDAYS and, where applicable, provide a holiday range or select a custom weekend pattern with NETWORKDAYS.INTL.

Before settling on a formula, answer three questions: Are weekends part of the count? Should today count as a remaining day? Should a past deadline display as a negative number, zero, or an overdue status? These decisions affect the meaning of the result more than the cell formatting does. Writing the rule in a heading or note beside a shared tracker helps teammates interpret the number consistently.

Frequently Asked Questions

Does Excel have a built-in days-left function?
No dedicated days-left function is needed. Subtract TODAY() from the cell containing the deadline to calculate the calendar-day difference. Use NETWORKDAYS when you need a weekday count rather than a calendar-day count.

Why does Excel show a date instead of the number of days?
The result cell is probably formatted as a date. Change its number format to General or Number using Home > Number Format. The formula result is a count, so a date display format makes it look confusing.

How do I stop the result from going below zero?
Wrap the date subtraction in MAX with zero as the other value. This displays zero after the deadline has passed, but it also hides how many days overdue the item is.

Can Excel count only business days and ignore holidays?
Yes. NETWORKDAYS counts standard Monday-to-Friday workdays and accepts a range of holiday dates to exclude. Use NETWORKDAYS.INTL if your weekend days differ from Saturday and Sunday.

Why does the number change when I open the workbook tomorrow?
TODAY() returns the current date, so a days-left formula recalculates as time passes. That changing value is expected. Use a fixed reference date instead if the workbook must preserve a historical calculation.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.