Mohammad Younous
Member
How find how many month between 2 date
8-Jun-2014 - 15-Apr-2015 = how many month
8-Jun-2014 - 15-Apr-2015 = how many month
Only Month Count. Like Jun, Jul, Aug, Sep, Oct, Nov, Dec, Jan, Feb, Mar, Apr = 11Assuming 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
Thanks a lotHi,
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,
You are welcome YounousThanks a lot