Excel Day Countdown: Build a Live Days-Left Formula

With a deadline date in B2, enter =B2-TODAY() in C2 to show how many calendar days remain. For example, if today is November 2, 2026, and B2 contains November 10, 2026, the result is 8. The countdown updates when Excel recalculates the workbook.

What an Excel day countdown tells you

A day countdown is the difference between a target date and today, expressed as a number of days. It is useful for tracking due dates, appointments, trips, renewals, launches, or any other event with a date in the future. The basic calculation uses calendar days: Saturdays, Sundays, and holidays all count.

Excel stores real dates as serial numbers, so subtracting one date from another produces the number of days between them. A date cell may look like “Nov 10, 2026,” but Excel calculates with its underlying number. The TODAY function supplies the current date, without a time, and changes as the date advances.

The basic result is a number, not a sentence. A result of 8 means the target date is eight date changes away; it does not mean eight full 24-hour periods remain. If you need to count both today and the event date as included days, that is a different convention, explained below.

Set up the date and countdown cells

Put a clear heading such as “Deadline” in B1 and “Days left” in C1. Enter the target date in B2, then put the countdown formula in C2. For an actual date, type a recognizable date such as 11/10/2026 or select the cell and enter it using your regional date format. You can also use Home > Number Format to choose a date display.

With the deadline date in B2, the formula in C2 is =B2-TODAY(). If B2 is November 10, 2026, and the current date is November 2, 2026, C2 returns 8. If B2 is November 1, 2026, the same formula returns -1, indicating that the date has passed by one day.

For a list, enter a different deadline in each row and copy the formula down. For example, if B2:B20 contains dates, place the calculation in C2 and fill it through C20. The relative reference changes automatically to B3, B4, and so on. In Microsoft Excel for Microsoft 365 on Windows, you can drag the fill handle at the bottom-right corner of C2 down the column. The formula works the same in Excel for Mac and Excel for the web.

Choose how to count the days

The ordinary countdown excludes today and measures the date difference. That is why November 2 to November 10 gives 8, rather than 9. For most “days until” questions, this is the expected interpretation: the target date is eight days away.

If your process counts both the current date and the target date as included calendar days, add one. With the deadline in B2 and today November 2, 2026, this formula returns 9 for a November 10 deadline: =B2-TODAY()+1. Use inclusive counting only when it matches the rule you are following, such as a schedule that labels every date in a date range as a day of the event. It is not inherently more correct than the ordinary difference.

Decide what should happen after the deadline, too. A negative result is informative when you want to see how late an item is. If the display should stop at zero instead, use this formula with the deadline in B2: =MAX(0,B2-TODAY()). For a November 10 deadline on November 2, it returns 8; for a deadline that has passed, it returns 0 rather than a negative number. This hides the number of overdue days, so it is less suitable for a late-work report.

Show a readable status instead of a bare number

You can combine the day count with words for a quick status label. With a deadline in B2, put this formula in C2: =IF(B2<TODAY(),"Overdue",B2-TODAY()&" days left"). If B2 is November 10, 2026, and today is November 2, it returns “8 days left.” If the deadline was yesterday, it returns “Overdue.” A deadline of today returns “0 days left.”

This formula returns text, so C2 is no longer a simple numeric count. That matters if you later want to average or sort the countdown values numerically. A practical layout is to keep the number in one column and put a separate status formula in another, or use cell formatting to make the number easier to read without changing its type.

To format the numeric result, select the countdown cells and choose Home > Number Format > Number, then set decimal places to zero. If the result appears as a date, Excel may have applied a date format to the result cell. Change it to General or Number; the underlying calculation may already be correct.

Count workdays rather than calendar days

For a work deadline, you may want to count weekdays and exclude weekends. Excel’s NETWORKDAYS function counts working days between two dates, including both endpoints when they are workdays. To count weekdays after today through the deadline, use a start date of tomorrow. With the deadline in B2 and no holidays to exclude, the formula is =NETWORKDAYS(TODAY()+1,B2). If today is Monday, November 2, 2026, and the deadline is Tuesday, November 10, it returns 6: Tuesday through Friday and the following Monday and Tuesday.

You can also exclude holidays listed in cells. With the deadline in B2 and holiday dates in D2:D5, use =NETWORKDAYS(TODAY()+1,B2,$D$2:$D$5). For the November 2 to November 10 example, it returns 5 if one of those six weekdays is listed as a holiday; it returns 6 if none of the dates in the range is a weekday holiday. The dollar signs keep the holiday range fixed when you copy the formula down.

These examples assume a future deadline. If the deadline is today or already past, the calculation may not match the label “workdays remaining,” because the function counts dates in its supplied range. For a report that handles past dates differently, add a separate overdue status or explicitly define the desired result for dates at or before today. Also note that NETWORKDAYS treats Saturday and Sunday as weekends. For a different regular weekend pattern, Excel provides NETWORKDAYS.INTL.

Track several deadlines and highlight urgent ones

A simple table can make a countdown useful across a project. Put task names in A, due dates in B, day counts in C, and an optional owner or status in D. Keep one task per row, use a consistent date format, and fill the countdown calculation down beside the dates. You can sort by the numeric countdown column to bring nearer deadlines to the top. If overdue items should appear first, sort the negative values ahead of positive ones or keep a separate status column.

Conditional formatting can make urgent dates stand out without adding text to the calculation. Select the countdown cells, then choose Home > Conditional Formatting > Highlight Cells Rules > Less Than. Enter 4 to highlight values below four; this includes zero and negative overdue values. Add another rule for less than 8 if you want a second warning level, choosing a different format for each rule. Check the rules’ Applies to range if you add rows later, so new countdown cells receive the intended formatting.

For a date-based warning instead of a number-based one, apply a rule to the deadline dates themselves. Select the date range and use Home > Conditional Formatting > Highlight Cells Rules > A Date Occurring to choose an available period, or use a numeric countdown column when your threshold needs to be exact. Formatting changes appearance only; it does not alter the date or countdown value.

Handle deadlines that include a time

TODAY is appropriate when the deadline is a date and the time of day does not matter. If B2 contains a date and time, subtracting TODAY() still compares it with midnight today. The result can therefore include the fraction of a day until the stated time, even though the cell may display as a whole number.

For a precise countdown to a date-and-time deadline, use NOW instead. With the deadline date and time in B2 and the current time at 9:00 a.m., a deadline at 11:00 a.m. today gives =B2-NOW() a result of one-twelfth of a day, which is two hours. Format the result as a duration: open Format Cells, choose Custom, and use [h]:mm. The square brackets allow elapsed hours to accumulate beyond 24, unlike a clock-time format that rolls over each day.

Both TODAY and NOW are volatile functions: Excel updates them when the workbook recalculates. They are not a continuously running timer that refreshes every second. If the displayed value seems stale, check Formulas > Calculation Options > Automatic, then recalculate or reopen the workbook. Excel for Mac and Excel for the web support these standard functions too, though the ribbon layout can vary slightly.

Common countdown problems and their fixes

The result is a date or looks like ####. The formula result cell may have a date format, or the column may be too narrow. Set the cell to General or Number and widen the column. A negative value displayed with a date format can also produce hash marks.
The formula returns an error or an unexpected value. Check that B2 contains a real Excel date, not text that only resembles one. Select the cell and change its format; if the value does not behave like a date, re-enter it in a recognizable format or convert the imported text to dates.
The countdown does not change at midnight. Excel recalculates volatile formulas when calculation occurs, not as a background clock. Confirm automatic calculation is selected and trigger recalculation if necessary.
It shows a negative number. The deadline has passed. Keep the negative value if you need to measure lateness, use a status label, or cap the result at zero if overdue days should be hidden.
The count is off by one. Check whether you intend to exclude today, include both endpoints, or count only working days. These are different counting rules, not necessarily formula errors.

When a formula is copied, also check that it still points to the correct deadline cell. If the formula references another column or a holiday list, use absolute references for ranges that should not shift. A blank deadline can otherwise produce a misleading number because a blank cell is treated like zero in many arithmetic calculations. Keep unused rows visibly blank or add a blank check when you build a larger tracker.

Frequently Asked Questions

Does Excel have a built-in day countdown button?
No special countdown button is needed for a basic tracker. Subtracting TODAY() from a date cell produces a live calendar-day count, and ordinary worksheet formatting can make the result readable.

Does a countdown formula update automatically every day?
It updates when Excel recalculates the workbook. With calculation set to Automatic, opening or recalculating the workbook refreshes TODAY and NOW; they do not act as second-by-second timers.

How do I stop the countdown at zero?
Use the MAX-based formula above to return zero for a past deadline. Choose that behavior only if you do not need to know how many days late the item is.

Can Excel count only weekdays?
Yes. Use NETWORKDAYS to exclude Saturday and Sunday, and provide a holiday range as its optional third argument. For a nonstandard weekend, use NETWORKDAYS.INTL.

Why does my countdown show a decimal?
A decimal can appear when the dates include times, or when the result cell is formatted to show decimal places. For date-only countdowns, use dates without times and set the result format to Number with zero decimal places.

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.