Accrual Vacation Spreadsheet

Hello!

I have been tasked with making a spreadsheet to help out with keeping track of vacation days. I have researched all the other posts on here about this and am still beyond confused. I need the spreadsheet to restart the PTO days on the anniversary date and to apply a max of 10 days left over from the prior year.

So right now this is the information I have.

Years Worked PTO Hours PTO Days Accrual Rate
1-2 years 80 10 3.333
3 years 120 15 5.000
4 years 160 20 6.667
5 + years 200 25 8.333

The sample Employee start dates I am using is:
Employee 1- 08/15/16
Employee 2- 07/01/10
Employee 3- 01/24/07

Thank you so much for any help!!