How do I calculate age from a birthdate in Excel 2002?
 

I have a list of 3600 birthdates and I need a formula to calulate ages.

How do I calculate age from a birthdate in Excel 2002?
 

=DATEDIF(DOB,TODAY(),"Y")

for years where DOB is the cell with the birth date


see

http://www.cpearson.com/excel/datedif.aspx

for more info




--


Regards,


Peo Sjoblom


"Carly" wrote in message
...
I have a list of 3600 birthdates and I need a formula to calulate ages.