years of service

[Shorty]

Hi, I'm looking for a formula to calculate the years of service. If ones
hire date was 05/25/2004 then the designated cell needs to show "1". Thank
You

 

[MS Office]

Hi

Assuming that the year of service is recorded in Cell A1, try this formula
:-
=YEAR(TODAY())-YEAR(A1)

P.s. you may need to change the cell fromat to number ( Fromal > Cell >
Number)

 

[David McRitchie]

That will only work for dates that have already had their anniversary
this year. i.e. Dec 25, 2004 would not have one year of service
in Sept 2005.

Surprised there weren't other answers, for one answer see datedif in
http://www.cpearson.com/excel/datedif.htm