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" wrote in message ...
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" wrote in message
...
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" wrote in message
...
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"
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" wrote in message
...
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"
wrote:

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