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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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.
 
You must log in or register to reply here.

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
date of birth age formula 8
How do I calculate a persons age from birth dates 1
How do I calculate a person's age from date of birth and a date 2
Convert date to Age 3
DB design questions 6
Calculate age 3
age calculations 2

Back
Top