I used both of these -
=DATEDIF(E5,TODAY(),"y")
and
=FLOOR(DATEDIF(B5,TODAY(),"m")/12,1)

They both work good. Thanx All!


Jim


--
Ltat42a
------------------------------------------------------------------------
Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735
View this thread: http://www.excelforum.com/showthread...hreadid=498378