formula to calculate age using birth date and current date
 

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

formula to calculate age using birth date and current date
 

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

--
Regards,

Peo Sjoblom

(No private emails please)


"lalah" wrote in message
...
what formula would you use to calculate current age given the birth date
and
current date in the worksheet

formula to calculate age using birth date and current date
 

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

lalah wrote:

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

--

Dave Peterson