See Chip Pearson's website:

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

Check the "Calculating A Person's Age" section

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Sonia" wrote:

I'm very new to Excel, so my question may seem basic.

I am trying to calculate one's current Age by inputting their date of birth.
I tried subtracting the two dates, but I get a date and I cannot format that
to an age.

I would actually like the data in the cell to show the age in years and
months (i.e. 3.8 to tell me the age is 3 years and 8 months).

Any help is appreciated. Thanks.