Hi!
I am attempting to create a spreadsheet to track my employees' PTO based on when it is accrued and when/what they use. My spreadsheet is a mess right now and really confusing.
Accrual:
Year 1 = 1 day/month (12 days total)
Years 2-10 = 1.25 days/month (15 days total)
The accrual is by the hire date - anniversary of hire date (Aug 2012-Aug 2013) and the day isn't actually accrued until the start of the next month (have to work the month to earn the day).
Please help! It's a small office with just 5 employees that I need a spreadsheet for. We do not have vacation/sick/personal, just general PTO.
Thanks! (my wreck of a spreadsheet is attached right here) PTO Calculations.xlsx
Bookmarks