Take a look at Chip Pearson's site for =DateDif()
http://www.cpearson.com/excel/datedif.htm

Sohoma Knome wrote:

I need to determine how many years employees have been here. I know the
start date (example 6/02/98) At the end of this year (12/31/2005) this
person has been here 7 1/2 years. What is the formula to have excel figure
this, and display it in number form 7 1/2 or 7.5.

--

Dave Peterson