Thread: How do I calculate age from a birthdate in Excel 2002?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
  
Posts: 3,268
Default 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.


Reply With QuoteReply With Quote