This is one option:

A1: birthdate
B1: =DATEDIF(A1,TODAY(),"Y")&" years &
"&MOD(DATEDIF(A1,TODAY(),"M"),12)&" months"

Ola Sandström


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=374933