How do you calculate age from just having a Date of Birth?

A

Alex

I am trying to calculate age in years from having a date of birth. I have the
date in a format ie. 14/08/1979. At the moment I have done formula
=YEAR(A3)-YEAR(A2), but am unsure as to how accurate this is and will this
just calculate the whole years and not take into account if that person has
had a birthday that year etc?
Thanks
Alex
 
M

Mike

Where D7 = DOB
and D8 is todays date

=DATEDIF(D7,D8,"y") & " y, " & DATEDIF(D7,D8,"ym") & " m, " &
DATEDIF(D7,D8,"md") & " d"
 

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

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 4
date of birth age formula 8
Calculating age from date of birth and ignoring if blank 3
Using Year of Birth, from DOB, in later calculations 6
HOW DO YOU CALCULATE AGE BY DATE OF BIRTH I NEED YEARS AND MONTHS 2
Calculate age with an end date 3
Age 9

Top