HOW DO YOU CALCULATE AGE BY DATE OF BIRTH I NEED YEARS AND MONTHS

D

dallyup2

How do you calculate age by a birth date I need years and months... if the
person is not a year old I need to know how many months... if the person is
1yr 2mo I need it to return 1yr 2mo... if the person is only 2mo I need it to
return 2mo.. is there any kind of formula that could work...

Thanks Donna
 
D

Dav

If you subract the DOb from today() so if the dob was in cell A1

in b1 put today()-a1

Go to format cell ans select the custom number format then type
yy "years" m "months"

regards

Da
 
M

Millerk

Use the following formula in the cell you want the age of person to appear.

=DATEDIF(A5, NOW(), "y") & " yr, " & DATEDIF(A5, NOW(), "ym") & " mo"

This formula would be in B5 and the persons DOB would be in A5

Hope this helps.
 

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

changed DOB to age, but if no DOB need cell to be empty. 4
Convert date to Age 5
Calculate horses age as at 1 August 6
date of birth age formula 8
How do I calculate a persons age from birth dates 1
Expanding Date formula 2
How do I calculate a person's age from date of birth and a date 4
New computer, how do i move outlook 365 ENTIRELY? 0

Top