Exceljet

Quick, clean, and to the point

Get days between dates

Excel formula: Get days between dates
Generic formula 
=later_date-earlier_date
Explanation 

T calculate the number of days between two dates you can simply subtract the older date from the newer date. The result will be an integer that represent the days between dates. In the example shown, the formula in D6 is:

=C6-D6

The result is 365, since there are 365 days between 1/1/1999 and 1/1/2000.

Note: make sure you format the result with the General number format.

How this formula works

Dates in Excel are simply serial numbers that start on 1/1/1900.

In the example, the formula in cell D6 simply subtracts the numeric value of 1/1/1999 (36161) from the numeric value of 1/1/2000 (36526) to get a result of 365. The steps look like this:

=C6-B6
=1/1/1999-1/1/2000
=36161-36526
=365

Working with today

If you need to calculate the number of days between an earlier date and today, use:

=TODAY()-earlier_date

To calculate the number of days between a later date and today, use:

=later_date-TODAY()

Note that TODAY will recalculate on an on-going basis. If you open the workbook at a later date, the value used for TODAY will update and you will get a new result.

The DAYS function

The DAYS function, introduced in Excel 2013, also calculates days between two dates.

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.

Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Shortcuts Video Course
Excel Charts video training course
Video training for Excel Tables