How to Calculate Number of Months Between Dates in Excel

In this tutorial, you will learn how to calculate the number of months between dates in Excel.

You would need to know how many months have gone between two dates if you were in charge of several projects. Alternatively, if you’re planning a project, you might need to know the start and end dates as well.

Once you are ready, we can start by using real-life scenarios to help you understand how to calculate the number of months between dates in Excel.

Calculate the Number of Months Between Dates in Excel

Before we begin we will need a group of data to be used to calculate the number of months between dates in Excel.

Step 1

First, you need to have a clean and tidy group of data to work with.

Step 2

In this example, we want to find the number of months and days between the start and end dates of these 4 projects. To do so we will use the DATEIF function. We can insert the following formula =DATEDIF(A2,B2,”M”)&”M “&DATEDIF(A2,B2,”MD”)&”D”.

Step 3

Once we are done, the formula returns the number of months and days between the 2 dates.