Bob Phillips Wrote:
Can't see where you get 0.6 from, as that is only 3 months by my calcs,
which is .25, but maybe this helps

=DATEDIF(A1,TODAY(),"y")+DATEDIF(A1,TODAY(),"ym")/12



Couldn't you get the same result with

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


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=556785