Use the DATEDIF function, described here on Chip Pearson's site:

http://www.cpearson.com/excel/datedif.aspx

(it is not described in Excel Help, other than in XL 2000).

Hope this helps.

Pete

On Apr 23, 1:16*pm, HelpDeb wrote:
I have to determine the age of an employee on the day they start employment
and the day they end employment. *I have their birthdate in Column A, date of
hire in Column B, date of termination in Column C. *I have too many names to
do this by hand. *What is the formula for calculating the Age on their Date
of Hire (Column D) and the Age on their Date of Termination (Column E). *Any
help would be appreciated!