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

Top