Oh, shoot.. After a bit of testing, I just noticed this doesn't work with non-excused. The current formula doesn't accrue days when you enter in a non excused day.

So in example, an employee only has 1 unexcused sick day for the month. He doesn't earn a day with this formula. It's simply just subtracting one. We're soo close! lol I tried to add the non excused days to the count, and it works "KIND OF" but then after testing it, if I have 1 excused day and 1 non excused day (A total of 2) it ends up adding both of them, and not subtracting (1) day. if that makes sense.. lol

one excused day and one non excused, should only subtract one available sick day, since we're calculating the accruing day in the formula.

=MAX(0,MIN(60,D5-AD5-AE5+COUNT(F5,G5,H5,I5,J5,K5,L5,M5,N5,O5,P5,Q5,R5,S5,T5,U5,V5,W5,X5,Y5,Z5,AA5,AB5,AC5))))

So in short, I guess if we started with 45, and had 1 excused day, and one non excused day..

This would be 45-1-1+2 (count) When it should be 45-1-1+1 (No freakin clue what needs to make this work) lol.

## Like this thread? Share it with others