How to Calculate Difference Between Two Dates in Days in Excel

We’ll show you 7 quick methods of how to calculate the difference between two dates in days in Excel. To demonstrate our methods, we’ve picked a dataset with 3 columns: “Name”, “Date Joined”, and “Date Left”. In all our methods, we’re gonna find the number of days each employee worked in a company.

excel difference between two dates in days


Download Practice Workbook


7 Ways to Calculate Difference Between Two Dates in Days in Excel

1. Using DATEDIF Function to Find Difference Between Two Dates in Days in Excel

For the first method, we’re going to use the DATEDIF function to calculate the difference between two dates. This function is not listed in Excel, hence, no tooltip will be displayed for this function. We’ve added a column Days Worked” in our dataset.

Steps:

  • Firstly, type the following formula in cell E5.
=DATEDIF(C5,D5,"d")

The syntax of this function is DATEDIF(start_date,end_date,unit). Our initial date is on cell C5, the end date is on cell D5. and finally, we’re setting our output format to days using “d” in the function.

excel difference between two dates in days

  • Secondly, press ENTER.

We’ll see the date difference in days in cell E5.

excel difference between two dates in days

Read More: How to Calculate Time Difference in Excel Between Two Dates (7 Ways)


2. Use of DAYS Function to Find Date Difference in Days

For the second method, we’ll use the DAYS function to get the date difference in days.

Steps:

  • Firstly, type the following formula in cell E5.
=DAYS(D5,C5)

The syntax of this function is “DAYS(end_date,start_date)”.

Here, our end date is on cell D5 and the initial date is on cell C5.

  • Finally, press ENTER and AutoFill the formula.

We can see this is the simpler version of the DATEDIF function. Moreover, this is what the final step should look like.

excel difference between two dates in days


3. Calculating Difference Between Two Dates in Days Using DAYS360 Function

In this section, we’re going to use the DAYS360 function to find the difference between two dates in days.

Steps:

  • Firstly, type the following formula in cell E5.
=DAYS360(C5,D5)

The syntax of this function is “DAYS360(start_date,end_date)”.

Here, our initial date is on cell C5 and the end date is on cell D5.

  • Finally, press ENTER and AutoFill the formula.

This function assumes that every month consists of 30 days. Therefore, we’ll see some difference in the output from methods 1 and 2.

excel difference between two dates in days


Similar Readings


4. Using DATE Function to Find Difference Between Two Dates in Days

For the fourth method, we’ll use the YEAR, MONTH, DAY, and DATE functions to calculate the difference between two dates in Excel.

Steps:

  • Firstly, type the following formula in cell E5.
=DATE(YEAR(D5),MONTH(D5),DAY(D5))-DATE(YEAR(C5),MONTH(C5),DAY(C5))

Formula Breakdown

Firstly, our formula has two DATE functions. Finally, we’re subtracting the first date from the last date using those.

  • YEAR(D5),MONTH(D5),DAY(D5) will return 2022, 5, 10 respectively.
  • Now the first part of our formula reduces to -> DATE(2022,5,10)
    • Output: 44691.
    • Our output will be in a Serial Number format.
  • Similarly, our second portion will return 44621.
  • Finally, we’re subtracting it to get our date difference (44691-44621=70).

  • Finally, press ENTER and AutoFill the formula.

Thus, we’ve found the difference between the two dates in days format.

excel difference between two dates in days


5. Use of NETWORKDAYS Function to Calculate Difference Between Two Dates in Days in Excel

In this method, we’re going to use the NETWORKDAYS function to find date differences in days format. We’ve changed our dataset a little bit by adding 2 holidays.

Steps:

  • Firstly, type the following formula in cell E5.
=NETWORKDAYS(C5,D5,$C$13:$C$14)

The syntax of this function is “NETWORKDAYS(start_date, end_date, [holidays])”.

Here, our initial date is on cell C5 and the end date is on cell D5 and our holidays are in cell range C13:C14. Moreover, remember to use absolute cell references in this function.

excel difference between two dates in days

  • Secondly, press ENTER.

  • Finally, AutoFill the formula.

In conclusion, we’ll find the Workdays in days between the dates.

excel difference between two dates in days

This function considers Saturday and Sunday as Weekends. However, if you want to change the Weekends, you need to use the NETWORKDAYS.INTL function.


6. Find Difference Between Two Dates in Days in Excel Using a Generic Formula

In this section, we’ll use a generic formula to calculate the date differences in days.

Steps:

  • Firstly, select the cell range E5:E10.
  • Secondly, type the following formula.
=D5-C5

Here, we’re just simply subtracting the end date from the starting date.

  • Finally, press CTRL + ENTER.

This will AutoFill our formula.

excel difference between two dates in days

Read More: Excel formula to find difference between two numbers


7. Use of TODAY Function to Find Difference Between Two Dates in Days in Excel

For the last method, we’re gonna use the TODAY function and subtract the initial date value from it to find our date difference. We’ve removed a column from our dataset.

Steps:

  • Firstly, select the cell range E5:E10.
  • Secondly, type the following formula.
=TODAY()-C5

Here, we’re just simply subtracting the end date from today’s date. Therefore, your value will not be the same when you open this file. Moreover, if you have a large dataset, you should avoid using this function, as it will slow down your computer.

excel difference between two dates in days

  • Finally, press CTRL + ENTER.

This will AutoFill our formula. Thus, we’ve shown you yet another formula to find the difference between two dates in days format in Excel.

Read More: How to Calculate Time Difference Between Two Dates in Minutes in Excel


Practice Section

We’ve added practice datasets for each method in the Excel file.

excel difference between two dates in days


Conclusion

We’ve shown you 7 methods of how to calculate the difference between two dates in days in Excel. However, If you face any difficulties, feel free to comment below for assistance. Thanks for reading, keep excelling!



Related Articles

Rafiul Haq

Rafiul Haq

Hello! This is Rafiul. I am passionate about all things related to data and MS Excel is my favorite application. I want to make people's life easier by writing easy-to-follow and in-depth guides here at Exceldemy.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo