I need help on having a spreadsheet where I can enter an employees days (by the dates) they are off. have those days subtract from their availability days/hours.
Then I need to show how many hours they have accrued based on their years of service. I have to formula to count what week it is but I don't know how to have the rate changed based on their year of service. So how do I enter each different date (each time they take off) so that is works with the days available then how to I get the accrual rate to change with the years of service. I have attached what I started
The rate goes
0-2 - 80 hours
3-5 - 120 hours
6+ 160 hours
Should I add a type of calendar to track the days
Bookmarks