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!!
Bookmarks