Calculate Days Left in Excel with Simple Formulas

Formulas & functions · Updated November 21, 2026

To calculate days left in Excel, enter the deadline in A2 and use =A2-TODAY() in another cell. Excel returns the number of calendar days from today to that date: a positive number means days remain, zero means the deadline is today, and a negative number means it has passed.

How the days-left formula works

Excel stores dates as serial numbers, so subtracting one date from another gives the number of days between them. The formula compares the date in A2 with the current date returned by TODAY(). For example, if today is October 10 and A2 contains October 15 of the same year, the result is 5. The deadline day itself is not counted as a full day remaining; the result measures the gap between the two dates.

TODAY() updates when Excel recalculates the workbook, usually when the file is opened or a change triggers recalculation. That makes the formula suitable for a live countdown: tomorrow, a deadline that showed 5 will show 4. It does not update continuously like a running clock, and a workbook in manual calculation mode may not refresh until you recalculate it.

To set up a basic countdown:

  1. Type a deadline into A2 and make sure Excel recognizes it as a date.
  2. Enter the formula in B2.
  3. Press Enter. If the result appears as a date, format B2 as General or Number.
  4. Copy the formula down column B for additional deadlines. Excel adjusts A2 to A3, A4, and so on.

Choose whether today counts

The standard subtraction formula counts the number of date boundaries between today and the deadline. If the deadline is today, it returns 0. Some plans or instructions instead define today as one of the days available. In that case, add 1 to the difference. With the deadline in A2, use =A2-TODAY()+1 for an inclusive count. If the deadline is October 15 and today is October 10, that calculation returns 6, counting October 10, 11, 12, 13, 14, and 15.

Be consistent about the counting rule when sharing a schedule. “Five days until Friday” commonly means the difference between today and Friday, while “five calendar days including today” is an inclusive count. Neither convention is universally correct; choose the one that matches the task, policy, or agreement. For a countdown that should never display a negative number, use =MAX(0,A2-TODAY()) with the deadline in A2. This shows zero for dates that are today or in the past, but it also hides how overdue a past date is.

Count working days instead of calendar days

Calendar-day subtraction includes Saturdays, Sundays, and holidays. For a work schedule, Excel’s NETWORKDAYS function counts weekdays between two dates and can exclude a supplied holiday list. Its default weekend is Saturday and Sunday. Because NETWORKDAYS counts both endpoints when they are working days, a direct call starting today includes today. To count working days after today through a future deadline, use a start date of tomorrow.

For a future deadline in A2 and holiday dates in D2:D10, use =IF(A2<=TODAY(),0,NETWORKDAYS(TODAY()+1,A2,$D$2:$D$10)). The layout is A2 for the deadline and D2:D10 for holidays; the formula returns zero when the deadline is today or earlier, and otherwise counts eligible workdays from tomorrow through the deadline. For example, if today is Friday, October 10, the deadline is Wednesday, October 15, and there are no holidays in between, the result is 3: Monday, Tuesday, and Wednesday. Saturday and Sunday are not counted.

Enter actual Excel dates in the holiday cells, not weekday names or text labels. If your organization has a different weekend pattern, NETWORKDAYS.INTL lets you specify weekend days. Check the function’s weekend-code options in Excel Help and use the code that matches your workweek; do not assume the standard Saturday-Sunday weekend applies. NETWORKDAYS and NETWORKDAYS.INTL count whole working days, not work hours or partial days.

Format the result and make it readable

A correct formula can appear wrong if the result cell has an unsuitable number format. Excel may inherit a date format from nearby cells, causing a result such as 5 to display as a date in 1900. Select the result cells and choose Home > Number Format > General or Number. You can also use the Number Format drop-down on the Home tab. The underlying calculation has not changed; only its display has.

For a straightforward tracker, use headings such as Deadline and Days left, and keep the deadline column in a recognizable date format. Conditional formatting can help distinguish overdue items from upcoming ones. Select the result cells, then choose Home > Conditional Formatting > Highlight Cells Rules > Less Than and enter 0 to highlight negative results. A separate rule for values equal to 0 can flag deadlines due today. Formatting improves visibility, but it does not change the formula’s meaning.

If you want a word beside the number, keep the numeric countdown in its own cell and use a separate status column, or use a custom number format carefully. Keeping the result numeric makes it easier to sort, filter, chart, and use in other calculations. A text label that combines a number with words may be easier to read but is not as convenient for further arithmetic.

Common problems and how to fix them

  • The result displays as a date. Change the result cell’s number format to General or Number. This is a display issue, not necessarily a formula error.
  • The formula returns a large or unexpected number. Check that A2 contains the intended year. A date entered without a year may be interpreted using the current year, and dates can be ambiguous when day and month order differs by locale.
  • The formula does not change tomorrow. TODAY() is recalculated when Excel recalculates. Press F9 on Windows to recalculate formulas, or check Formulas > Calculation Options and select Automatic if appropriate. On Mac, use the equivalent Excel calculation commands; keyboard shortcuts can differ by keyboard and version.
  • The result is an error or does not calculate. Confirm that the deadline is a real Excel date rather than text that only looks like one. Re-enter it using a date format Excel recognizes, or use a cell’s date picker if available. Also check that the formula begins with an equals sign and that the cell is not formatted as Text.
  • The workday count is off by one. Decide whether today and the deadline should count, then account for NETWORKDAYS including working-day endpoints. Check the holiday list for missing dates or entries stored as text.

A useful way to diagnose a date is to temporarily change its format to General. A recognized date becomes a serial number; text generally remains text. Return the cell to a date format afterward. Also make sure dates are entered consistently: a deadline such as 04/05/2026 can mean April 5 or May 4 depending on regional settings.

Use a fixed starting date instead of today

Sometimes a countdown should be based on a project start date or a specific reference date, not the day the workbook is opened. Put the reference date in B2 and the deadline in A2. With those two cells, use =A2-B2. For example, if B2 is October 10 and A2 is October 15, the result is 5. Unlike TODAY(), the result remains unchanged unless someone edits one of the input dates.

This fixed-date setup is useful for reviewing a past plan or calculating the duration between two milestones. It also makes a workbook’s results reproducible: another person opening the file later sees the same interval. Use TODAY() when the question is “how many days remain from now?” and a stored start date when the question is “how many days were between these two dates?”

Dates with times and other counting choices

Excel dates can include a time portion. If A2 contains a deadline such as October 15 at noon, subtracting TODAY() may produce a fractional number because the time is part of the stored value. If you need whole calendar-date differences regardless of the time, use =INT(A2)-TODAY() with the deadline or timestamp in A2. INT removes the fractional part of the date-time serial. This is not the right choice when remaining hours matter; for an hours-based countdown, compare date-time values and format or convert the result to show the needed units.

Clarify what “days left” means before building a tracker. It might mean calendar days, business days, full days after today, or an inclusive count that includes today. A countdown also does not by itself determine whether a deadline expires at the start or end of the stated date. For a deadline at a particular time, store the time as well as the date and use a calculation designed for that level of precision.

Frequently Asked Questions

How do I calculate days left from today in Excel?
Put the deadline in A2 and enter =A2-TODAY() in another cell. Format the result as General or Number if Excel displays it as a date.

How do I show zero instead of negative days?
With the deadline in A2, use =MAX(0,A2-TODAY()). It returns the remaining days for future dates and zero for today or earlier dates. Use ordinary subtraction instead if you need to see how many days overdue an item is.

How do I count only weekdays between today and a deadline?
Use NETWORKDAYS, which excludes Saturday and Sunday by default and can exclude dates in a holiday range. Decide whether to include today: NETWORKDAYS counts working-day endpoints, so a formula starting tomorrow counts workdays after today through the deadline.

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; the formula can remain the same.

Does TODAY update automatically?
TODAY() returns the current date when Excel recalculates. It normally updates on opening or recalculation, but a workbook set to manual calculation may need recalculation before its countdown changes.

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.