Hi
formula from
http://www.cpearson.com/excel/datedif.htm#Age
=DATEDIF(A1,NOW(),"y") & " years, " & DATEDIF(A1,NOW(),"ym") & " months, " &
DATEDIF(A1,NOW(),"md") & " days"
Cheers
JulieD
"CFenton" wrote in message
...
How do I calculate an age from a birthdate in excel?