Difference Between Two Dates in Months in Excel (4 Suitable Examples)

Get FREE Advanced Excel Exercises with Solutions!

Sometimes you may need to know how many months have passed between two dates. There are multiple ways to find the difference between two dates in months in Excel. In this tutorial, you will learn 4 effective ways to get the difference between two dates in months in Excel.


How to Get Difference Between Two Dates in Months in Excel: 4 Effective Ways

Let’s first introduce our dataset. Suppose, there are some launch dates and closing dates of some random projects. Our goal is to calculate the difference between two dates in months in Excel.

4 Effective Ways to Get Difference Between Two Dates in Months in Excel


1. Use DATEDIF Function to Find Difference Between Two Dates in Months in Excel

If you wish to calculate only the total completed months between two dates, the DATEDIF function is for you. Just follow the steps below.

Steps:

  • Type the following formula in cell D5.
=DATEDIF(B5,C5,"M")

Here, B5 stands for the launch date, C5 stands for the closing date, and M stands for month.

Using DATEDIF Function to Find Difference Between Two Dates in Months in Excel

  • Then, press ENTER key and put the Fill Handle to the rest of the required cells.

Using DATEDIF Function to Find Difference Between Two Dates in Months in Excel

Finally, here is the result.

Using DATEDIF Function to Find Difference Between Two Dates in Months in Excel

Note:

The DATEDIF function doesn’t count the running month.

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


2. Using YEARFRAC along with INT or ROUNDUP Functions

The YEARFRAC function counts the fractional year in decimal between two dates. To remove decimals, we can use INT or ROUNDUP functions. Just follow the steps below.

Steps:

  • Write down the following formula in cell D5.
=INT(YEARFRAC(B5,C5)*12)

Here, at first, the YEARFRAC function calculates the number of years in decimal format between two dates. Then, we use the INT function to convert a decimal to a whole number after multiplying by 12.

Using YEARFRAC along with INT or ROUNDUP Functions

  • Then, press the ENTER key. Drag the Fill Handle icon to the rest of the cells.

Using YEARFRAC along with INT or ROUNDUP Functions

Finally, here is the output.

Note:

We can use the ROUNDUP function instead of the INT function. The INT function only rounds off the decimal even if it is closest to a whole number. On the other hand, the ROUNDUP function returns the nearest whole number or to a fixed decimal number according to round-off rules.


Similar Readings


3. Combine YEAR and MONTH Functions to Get Month-Difference Between Two Dates in Excel

Here is another effective method you can apply to get the difference between two dates in Excel. Follow the steps below to apply these functions.

Steps:

  • Copy the following formula and paste it into cell D5.
=(YEAR(C5)-YEAR(B5))*12+MONTH(C5)-MONTH(B5)

Here, at first, the YEAR function returns the difference between two dates in years. Then, after multiplying by 12, it is converted into months. Finally, it is added to the difference between two dates in months resulting in the the MONTH function.

Combining YEAR & MONTH Functions

  • Then, hit the ENTER key and drag the Fill Handle all the way.

Combining YEAR & MONTH Functions

Finally, here is the output.


4. Use a Subtraction Formula with Excel MONTH Function

To find the difference between two dates, you can simply use the MONTH function with the subtraction formula. Just follow the steps below.

Steps:

  • Go to cell D5 and type the following formula.
=MONTH(C5)-MONTH(B5)

Here, the MONTH function only returns the date difference in months within a fixed year.

Using Subtraction Formula with MONTH Function

  • Press ENTER.

Finally, you will get the result.

Using Subtraction Formula with MONTH Function


Download Practice Workbook

Download the following Excel file for your practice.


Conclusion

In this tutorial, I have discussed 4 effective ways to get the difference between two dates in months in Excel. I hope you found this article helpful. Please, drop comments, suggestions, or queries if you have any in the comment section below.

Hafiz Islam
Hafiz Islam

Hi there. I am Hafiz, graduated from BUET. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. Now you can see my articles in the ExcelDemy blog.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo