Calculating Current Age from DOB

G

Guest

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.
 
G

Guest

Try to custom format the difference cell like yy.mm

Regards,
Stefi

„Sonia†ezt írta:
 
A

aidan.heritage

I work in the insurance industry in the UK - we USUALLY use the
YEARFRAC function for this - this requires that you use the tools menu,
add-ins to add-in the Analysis toolpak, but it then makes the return
nice and easy - yearfrac gives an exact value, but can be modified to
return years and months by multiplying the returned value by 12, taking
an integer of it, then dividing back by 12!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Calculate age from DOB in years, months days 7
Calculating age from date of birth and ignoring if blank 5
age 3
Calculating age of death 23
calculate which cells arrives first 1
Excel formula calculating age 4
Error message needed if incorrect Date Of Birth (DOB) entered 4
"how do I calculate age by using date of birth details" 5

Top