years of service

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

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)



"Shorty" <Ahoy28@dodgeit.com> wrote in message
news:ratTe.724$zq6.496@newssvr27.news.prodigy.net...
> 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
>
>

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
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"MS Office" <mantrimukesh@hotmail.com> wrote in message news:upxXH91sFHA.1172@TK2MSFTNGP11.phx.gbl...
> 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)
>
>
>
> "Shorty" <Ahoy28@dodgeit.com> wrote in message
> news:ratTe.724$zq6.496@newssvr27.news.prodigy.net...
> > 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
> >
> >
>
>