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

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

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

Your formula just calculates years.

Have a look at the DATEDIF function. This function is undocumented in XL's
help; however, here is some info: http://www.cpearson.com/excel/datedif.htm

Dave
--
Brevity is the soul of wit.


"Alex" wrote:

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

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

Where D7 = DOB
and D8 is todays date

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

"Alex" wrote:

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