Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Years of Service Calculation
I am struggling to find a calculation to figure out years of service by a
specific date in decimal format. My worksheet looks like the following: Column A: Hire Date ex:8/17/05 Column B: 4/1/2006 (need this date for calculating, date doesn't change) ex:4/1/2006 Column C: Years of Service ???????? (decimal format, in years) If anyone could help, I would appreciate! JS |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Years of Service Calculation
=(B1-A1)/365
MH "JS" wrote in message ... I am struggling to find a calculation to figure out years of service by a specific date in decimal format. My worksheet looks like the following: Column A: Hire Date ex:8/17/05 Column B: 4/1/2006 (need this date for calculating, date doesn't change) ex:4/1/2006 Column C: Years of Service ???????? (decimal format, in years) If anyone could help, I would appreciate! JS |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Years of Service Calculation
Thanks MH!
"JS" wrote: I am struggling to find a calculation to figure out years of service by a specific date in decimal format. My worksheet looks like the following: Column A: Hire Date ex:8/17/05 Column B: 4/1/2006 (need this date for calculating, date doesn't change) ex:4/1/2006 Column C: Years of Service ???????? (decimal format, in years) If anyone could help, I would appreciate! JS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Age and Number Years of Service | Excel Discussion (Misc queries) | |||
Years of Service Question? | New Users to Excel | |||
Years of Service Question? | New Users to Excel | |||
Calculate Years of Service | Excel Worksheet Functions | |||
Help with Years of Service formula.... | Excel Discussion (Misc queries) |