Vacation Tracker earned days off based on years employed

I am needing help with the following

I have spreadsheet that states employees hire date and formula to calculate that date to current date which auto generates the total years of employment.

I am needing the pro accrued cell to populate the days earned according to years worked

At 6 mos they earn 2 days
At 1 year they earn 8 more
At 2 years they earn 10
At 3 and 4 years they earn 13
At 5,6,7,8,9 they earn 17
At 10 years they earn 20
By: Amanda Zuniga

Leave a Reply

Your email address will not be published. Required fields are marked *