Have a formula...need an alternative.

[andyb16]

Hi All,

Background: I have a column with certain dates populated.

Objective: I need the difference between today and the date in the column represented not in days but number of months it eqates to.

My solution: ("Date Difference*12)/365

My query: Is there any alternative function in excel that converts numbers directly into months. OR is there a better formula than the one above that would also factor in say leap years?

Thanks!

 

[VoG]

If the date is before today try

=DATEDIF(A1,TODAY(),"m")

If it is after today reverse A1 and TODAY() in the formula.

 

[Gerald Higgins]

Why exactly are you unhappy with the solution you have now ?
It looks reasonably OK to me, given that calculating months is only ever going to be an approximation I think.

 

[gbrandreth]

Have you tried the YEARFRAC function

 

[andyb16]

Thanks All,

gbrandreth: Dunno how to work with YEARFRAC to give me a month fraction.

VoG: Your solutions works...thx!

Gerald: you r right..I am not unhappy with my solution...just trying to increase my knowledge of functions as I foresee that I may need to work with complex date data in the near future. Therefore looking to see if I can write shorter functions.