From the link:

Calculating A Person's Age

A frequent use of the DATEDIF is to compute someone's age based on the current date and their birthday. The formula below will return someone's exact age based on their birthday in cell A1.


=DATEDIF(A1,NOW(),"y") & " years, " & DATEDIF(A1,NOW(),"ym") & " months, " & DATEDIF(A1,NOW(),"md") & " days"

This will return a string like

33 years, 9 months, 18 days



"Epinn" wrote in message ...
In case you want to do some reading while you wait for an answer ......

http://www.cpearson.com/excel/datedif.htm#Age

Epinn

"jan" wrote in message ...
using excel 2003. try to calculate age from date of birth and another date.