Days between Dates

 

To calculate the number of days between two dates in Excel, subtract the start date from the end date, use DAYS or use DATEDIF.

1. Subtract the start date (A1) from the end date (A2).

Calculate Days Between Dates

2. Use the DAYS function in Excel 2013 or later. The first argument is the end date. The second argument is the start date.

DAYS function in Excel

3. Use the DATEDIF function. The first argument is the start date. The second argument is the end date. Fill in "d" for the third argument to get the number of days between two dates.

DATEDIF function

Tip: visit our page about the DATEDIF function to find out how to get the number of weeks, months or years between two dates in Excel.

4. The formula below returns the same number of days. Use the DATE function in Excel to hardcode a date.

Number of Days Between Two Dates

Explanation: the DATE function accepts three arguments: year, month and day.

5. Bonus. Use the NETWORKDAYS function to return the number of workdays between two dates in Excel. NETWORKDAYS excludes weekends (Saturday and Sunday).

Workdays Between Dates

Explanation: the NETWORKDAYS function includes the start date and the end date. The calendar below helps you understand this formula. Simply count the number of circles.

Calendar

Tip: visit our page about weekdays to learn more about the NETWORKDAYS function.