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

[Guest]

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

 

[Peo Sjoblom]

=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