Formula to calculate total no of months from any date to current date in excell - Your Solution World

featured-slider

ads

Hot

Post Top Ad

Your Ad Spot

Thursday, 8 June 2017

Formula to calculate total no of months from any date to current date in excell

In this post I will teach you how to calculate total number of months from given date to current date in Ms Excel

Formulla:=((YEAR(NOW())-YEAR(B2))*12+MONTH(NOW())-MONTH(B2))

Output is given below

No comments:

Post a Comment

Post Top Ad

Your Ad Spot