Forum Discussion
VACATION DAYS EXCEL FORMULA
Is there a way to prorate days for the time in between their anniversary date and Jan 1 when all vacation resets?
Maybe. Could you post a picture with a couple of expected results and explain how you calc. those results please?
- we add PTO days for employees on their 1st & 3rd year anniversary date of full-time employment. The prorated amount added on their anniversary date is:
JAN- FEB: 5 DAYS
MAR-MAY: 4 DAYS
JUNE-AUG: 3 DAYS
SEP-NOV: 2 DAYS
DEC: 1 DAY
Then on Jan 1 after 1 year they start with a fresh 5 days and then Jan 1 after 3 years they start with a fresh 10 days. No PTO days roll overI'm obviously very slow today 😞 Thanks for the explanation, though I also asked a picture showing a few expected results to make sure I understand and we don't waste time
I'll let other community contributors see if they can help you...
Lorenzo I apologize for the lack of picture. Currently I have this built where we enter the start date, I have the sick days that auto add 2 when they hit 90 days. The total days off auto calculate at the bottom based on B4 + B5. When they take a day off we enter the date in and it subtracts it from the total remaining. The only thing I don't have automated is what goes in B5, the number of vacation days.