Hi!
I'm trying to set an Excel spreadsheet for a small company (~50 employees), but I've been having some trouble.
1. We are paid bimonthly (15th and last day of the month)
2. When hired, employee need to complete a full year of work to start accruing vacation days. (If employee is hired on March 15, 2016.. until March 16, 2017 he/she will be able to enjoy paid leave). Here is the table:
YEARS OF WORK = VACATION DAYS
1 year = 6 days
2 years = 8 days
3 years = 10 days
4 years = 12 days
5-9 years = 14 days
10-14 yeats = 16 days
15+ years = 18 days
3. If you generate vacation days, but don't use them in the following year, you have 3 extra months to use them (rollover). If you don't, they cancel out and you are only left with the newly generated vacation days corresponding to hire date.
Thankyou in advance for your help!
Bookmarks