Calculate age as of a date certain

[Joe S.]

Employee benefit enrollment requires the age of each employee as of a
specific date, such as 1/1/2005. Given the date of birth, how would this be
calculated?

 

[Frank Kabel]

Hi
see:
http://www.cpearson.com/excel/datedif.htm#Age