I'm trying to set up a spreadsheet to keep track on staff vacation time off on accruel basis. I would like to quickly identify how many day each person has remaining, how many days have been used up, etc... I know the basics of excel, but this formula is too complicated and would appreciate someone's help. Here are the facts,
- 0 days -90 days - earn 0 vacation time
- 91 days - 12 months - earn 0.833
- 13 months - 60 months - earn 0.833
- 61 months - 120 months - earn 1.250
- 121 + months - earn 1.667
- Rollover from last period capped at 110%, stops acrruing until it's used up.
Thank you.
Bookmarks