Calculating an age at a certain date

[HelpDeb]

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!

 

[Pete_UK]

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

 

[Mike H]

Hi,

Put this In d1
=DATEDIF($A$1,B1,"y")
Drag to E1

Mike

 

[Mike H]

That shouls
d have been

=DATEDIF($A1,B1,"y")

Now it can be dragged down

 

[HelpDeb]

That is so cool! Thanks for your help. You're the man!