Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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. |
#6
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting up a spreadsheet to calculate apportionment of service cha | Excel Worksheet Functions | |||
calculate number of years | New Users to Excel | |||
Years of service... | New Users to Excel | |||
Calculate months and years | Excel Discussion (Misc queries) | |||
Help with Years of Service formula.... | Excel Discussion (Misc queries) |