G Guest Nov 20, 2005 #1 what formula would you use to calculate current age given the birth date and current date in the worksheet
what formula would you use to calculate current age given the birth date and current date in the worksheet
P Peo Sjoblom Nov 20, 2005 #2 =DATEDIF(DOB,TODAY(),"Y") -- Regards, Peo Sjoblom (No private emails please)
D Dave Peterson Nov 20, 2005 #3 Take a look at Chip Pearson's site for =DateDif() http://www.cpearson.com/excel/datedif.htm
