View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sonia
 
Posts: n/a
Default Calculating Current Age from DOB

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.