Datedif

I need to calculate the date difference between two dates and get the result in the number of years and proportion of months ie;

20/09/99 to 01/02/02 is 2.33333333 years. I can use the DATEDIF function to get 2 years 4 months as the result but for the calc I'm doing I need it in the format of 2.33333333. Thinking I just need to tweak the DATEDIF a bit but just can't work it out!

Any help greatly appreciated!

Cheers!

Try dividing the month part by 12 and adding that to the years, i.e.

=DATEDIF(A2,B2,"y")+DATEDIF(A2,B2,"m")/12

A1=20/9/99
A2=01/02/02
Try this formula:
=(A2-A1)/365

Try
=DATEDIF(A1,A2,"y")+DATEDIF(A1,A2,"ym")/12
Does that work for you?

ChemistB's suggestion was the one I was aiming for.....but thinking about it that will give you the same result as this

=DATEDIF(A2,B2,"m")/12