How find how many month between 2 date

[Mohammad Younous]

How find how many month between 2 date

8-Jun-2014 - 15-Apr-2015 = how many month

 

[Luke M]

Assuming earlier date is in A2, later date in A3:
=DATEDIF(A2,A3,"m")

 

[Khalid NGO]

Hi,
Another:

=(YEAR(A3)-YEAR(A2))*12+MONTH(A3)-MONTH(A2)
where 08/06/2014 in A2
and 15/04/2015 in A3

Regards,

 

[Mohammad Younous]

Assuming earlier date is in A2, later date in A3:
=DATEDIF(A2,A3,"m")

Only Month Count. Like Jun, Jul, Aug, Sep, Oct, Nov, Dec, Jan, Feb, Mar, Apr = 11

 

[Khalid NGO]

Only Month Count. Like Jun, Jul, Aug, Sep, Oct, Nov, Dec, Jan, Feb, Mar, Apr = 11

Hi,
Just add +1 at end
=DATEDIF(A2,A3,"m")+1
=(YEAR(A3)-YEAR(A2))*12+MONTH(A3)-MONTH(A2)+1

Previously it was counting the months Between dates.

Regards,

 

[Mohammad Younous]

Hi,
Just add +1 at end
=DATEDIF(A2,A3,"m")+1
=(YEAR(A3)-YEAR(A2))*12+MONTH(A3)-MONTH(A2)+1

Previously it was counting the months Between dates.

Regards,

Thanks a lot

 

[Khalid NGO]

Thanks a lot

You are welcome Younous