I'm trying to figure out the best way to track days off that employees earn throughout the year. The way it works is every year starting fresh for each 60 consecutive work days an employee is given a "Lieu Day" which is basically a bonus day off. Starting Jan. 1 if someone doesn't miss a day of work all year they would accumulate 4 Lieu Days. If someone has an unscheduled day off work, then the count starts over on their first day back to work. This happens each time an employee has an unscheduled day off. If an employee has work 80 consecutive days they would have earned 1 Lieu Day. If they request a day off and want to use their Lieu Day, I would like to be able to track this as well. For example, an employee hasn't had an unschedule day off all year and has worked 200 consecutive work days, but has used a Lieu Day; ideally the spreadsheet would show me that they currently have 2 Lieu Days available and are 40 days away from earning their next Lieu Day.
Hopefully this isn't too confusing. Any help would be great.
Thx
Bookmarks