Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vacation days from date of hire
I need to set up a worksheet that will allow me to calculate vacation days
from Hire date as follows: Employee works for 90 days (intro period), then will accrue 1 vacation day at the beginning of the first of the following month and one additional vacation day for each month after for a maximum of 10 days per year. Thereafter they receive 10 days on January 1st after their first 12 months of service. 4th thru 9th they will recieve 15 days on January 1st. -- cao |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FORMULA, DAYS WORKED TO VACATION DAYS | Excel Worksheet Functions | |||
Calculate vacation days remaining from date of employment | Excel Worksheet Functions | |||
vacation formula and 1/2 days | Excel Worksheet Functions | |||
Figuring Vacation Hrs. Earned using Current Date minus Hire Date | Excel Worksheet Functions | |||
I'm trying to count sick and vacation days | Excel Worksheet Functions |