Review of data for 90 day consecutive no miss
I am working on a time off accrual form for HR. per contract after June 1st of every year if an employee does not have an unexcused absence in 90 days they earn another personal day.
I have an accrual sheet that calculates vacation by hire date, personal days available at start of every calendar year and additional day after June 1st, but I can't figure the calculation to add the earned day (total of 4 to be earned).
I have another sheet for attendance that have a column for each unexcused absence up to 5, each is a date. Dates are manually entered.
How can I run it so it will review the attendance tracker for 90 days without an unexcused after June 1st and output 1 in the earned column so it can be added to total personal accrual?
Help Article Resources
Check out the Formula Handbook template!