Exceljet

Quick, clean, and to the point

Calculate days remaining

Excel formula: Calculate days remaining
Generic formula 
=end_date-start_date
Explanation 

To calculate the days remaining from one date to another, you can use a simple formula that subtracts the earlier date from the later date.

In the example shown, the formula in D5 is:

=C5-B5

How this formula works

Dates in Excel are just serial numbers that begin on January 1, 1900. If you enter 1/1/1900 in Excel, and format the result with the "General" number format, you'll see the number 1.

This means that you can easily calculate the days between two dates by subtracting the earlier date from the later date.

In the example shown, the formula is solved like this:

=C5-B5
=42735-42370
=365

Days remaining from today

If you need to calculate days remaining from today, use the today function like so:

=end_date-TODAY()

The TODAY function will always return the current date. Note that after the end_date has passed, you'll start to see negative results, because the value returned by TODAY will be greater than the end date.

You can use this version of the formula to count down days to an important event or milestone, count down days until a membership expires, etc.

Remaining workdays

To count remaining workdays, see the NETWORKDAYS function and the example here.

Author 
Dave Bruns

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.