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

G

Guest

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
 
G

Guest

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 person's age from date of birth and a date 2
How do I calculate a persons age from birth dates 1
date of birth age formula 8
HOW DO YOU CALCULATE AGE BY DATE OF BIRTH I NEED YEARS AND MONTHS 2
Calculating When Somebody Reaches a Certain Age 4
what formula do i need to calculate a persons age 12
Calculating age from date of birth and ignoring if blank 5
Calculate Age 5

Top