Thanks - works perfectly!

"via135" wrote:


hi

another try!

let us assume the date of birth is in A1

enter the formula in A2

=DATEDIF(A1,TODAY(),"Y")&"YEARS,"&DATEDIF(A1,TODAY (),"YM")&"MONTHS,"&DATEDIF(A1,TODAY(),"MD")&"DAYS. "

is it ok?

-via135


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=503394