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