Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I need to be able to input a beginning employment date, i.e., 10/12/1994 and
calculate the number of months between this date and the current date to determine the amount of vacation earned per month to be used in an IF formula. EXAMPLE: Start Date 06/13/85 current date 04/9/09 = How Many Months IF Statement would be If 0-60 months 8 Hours accrued each month, if 61-120 months 10 hours accrued each month, If 121-180 months 12 hours accrued each month. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating Average Length of Service | Excel Worksheet Functions | |||
Function to calculate the Length of Service of an Employee | Excel Worksheet Functions | |||
Employee Length of Service | Excel Worksheet Functions | |||
Length of service calculated in calender months. | Excel Discussion (Misc queries) | |||
Length of Service | Excel Worksheet Functions |