Vacation accrual

samia67

New Member
Joined
Sep 15, 2009
Messages
41
Hello,

I need help creating a vacation days tracking sheet. I Know this question MUST be answered a number of times over, however the examples I got when I searched are mostly based on hours. I need to accrue in days, and it starts the accrual after a 90 day probation following the hire date. There are different categories of allowed days/month. Days accrue as follows: less than 3yrs accrue 2 days/mth, 3-5yrs accrue 2.5 days/mth and casuals 1.5 days/mth. Absentism without notification will be deducted with the same no of days for each category. I need to see the days accrued, the days used, absentism & the balance (could I also have it include holidays, I'll enter them). Everyone's balance renews on their anniversary.

Please help. Thank you.

Samia
 

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

Watch MrExcel Video

Forum statistics

Threads
1,114,111
Messages
5,546,000
Members
410,720
Latest member
SSL
Top