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

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Where D7 = DOB
and D8 is todays date

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