Mega Code Archive - MSOfficeExcel 2007 Tutorial - Date Time Functions - Return the age of the person whose date of birth you enter into cell A1

Input the formula: =INT(YEARFRAC(TODAY(),A1,1))