To calculate number of months between 2 dates requires =Year and =Month formulas.

Before we get into it, let us first see how to calculate number of days between 2 dates.

 

To find number of days between 2 dates as super easy!

Simply negate the 2 cells,

  • Cell A2 has Start Date
  • Cell B2 has End Date
  • Simply put the formula in cell C2
    =B2 – A2
No of days formula

No of days formula

No. of days Answer

No. of days Answer

 

But if you want to calculate no. of Months between 2 dates, create the below Formula

  • Cell A2 has Start Date
  • Cell B2 has End Date
  • Simply put the formula in cell C2
    =(YEAR(B2)-YEAR(A2))*12+MONTH(B2)-MONTH(A2)
No. of Months formula

No. of Months formula

No. of months Answer

No. of months Answer

Understanding the Fomula

  • Year (B2) – Year (A2) * 12
    • This will calculate no. of years between the 2 dates and multiply it by 12 to get the no. of months
    • So if the 2 dates are falling in the same year, the answer to this part will be 0 * 12 = 0
  • Month (B2) – Month (A2)
    • This will calculate no. of months between the 2.
  • Both values are then added.

 

Keep Excel-ing!