formula to calculate age using birth date and current date

lalah · Nov 20, 2005

what formula would you use to calculate current age given the birth date and
current date in the worksheet

Peo Sjoblom · Nov 20, 2005

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

--
Regards,

Peo Sjoblom

(No private emails please)

Dave Peterson · Nov 20, 2005

Take a look at Chip Pearson's site for =DateDif()
http://www.cpearson.com/excel/datedif.htm