Calculate Years of Service

I am trying to find a formula for determining years of service using a Hire
Date and then today's date without having another column for today's date. I
enter my hire dates as mm/dd/yyyy and what to display years of service only
(no months-days). How can I make that work?
Thanks,
Jerry

Hi Jerry

Try
=DATEDIF(A2,TODAY(),"y")



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Jerry" <[email protected]> wrote in message news:[email protected]...
>I am trying to find a formula for determining years of service using a Hire
> Date and then today's date without having another column for today's date. I
> enter my hire dates as mm/dd/yyyy and what to display years of service only
> (no months-days). How can I make that work?
> Thanks,
> Jerry

I assume you want the figure by using only one cell. If an employee started
on the 19th of May 1978 try
=(TODAY()-DATE(1978,5,19))/365.25
Regards,
"Jerry" <[email protected]> wrote in message
news:[email protected]...
>I am trying to find a formula for determining years of service using a Hire
> Date and then today's date without having another column for today's date.
> I
> enter my hire dates as mm/dd/yyyy and what to display years of service
> only
> (no months-days). How can I make that work?
> Thanks,
> Jerry

Hi Jerry,
If you activate the Analysis ToolPak (tools, add-ins) you can get the
"NETWORKDAYS" function, which does not include the weekends or holidays(when
listed). This is normally done to figure out pentionable time by HR
personnel.

Gilles

"Jerry" <[email protected]> wrote in message
news:[email protected]...
>I am trying to find a formula for determining years of service using a Hire
> Date and then today's date without having another column for today's date.
> I
> enter my hire dates as mm/dd/yyyy and what to display years of service
> only
> (no months-days). How can I make that work?
> Thanks,
> Jerry

Just curious, but who calculates this in days? Where I worked (a university)
it was decimal years, i.e 5.03, 28.72, 30.15, etc.

On Sat, 19 Feb 2005 09:52:58 -0500, "Gilles Desjardins"
<[email protected]> wrote:

>listed). This is normally done to figure out pentionable time by HR
>personnel.

Don't know Myrna, I would think that calculating by days is more accurate.
But this is just a guess.
Gilles

"Myrna Larson" <[email protected]> wrote in message
news:[email protected]...
> Just curious, but who calculates this in days? Where I worked (a
> university)
> it was decimal years, i.e 5.03, 28.72, 30.15, etc.
>
> On Sat, 19 Feb 2005 09:52:58 -0500, "Gilles Desjardins"
> <[email protected]> wrote:
>
>>listed). This is normally done to figure out pentionable time by HR
>>personnel.
>