So the issue with that one is we have to have a 365 day rolling count for the hours in Col D Calendar tab, based on the date entered in Summary tab B4. When I change the date to 1/2/2018, it gives me an incorrect count in the Summary tab Col G. The count will need to reset to 1 as soon as the hrs >40. I have the formula in the Summary tab D7 but this cell hasn't been used since we created Cols D and E on the Calendar tab.
What is is JeteMc is in Oregon, an employee is allowed 40hrs of sick time per year that won't count as an unexcused employee illness. Once the employee has more than 40 hrs employee illness in any 365 day period, the unexcused illnesses would start at 1. Tricky puzzle