Hi All.
I'm running into a problem I don't know how to solve. I have set up a monthly chart to track when employees call in sick or other activities (ex. Holidays, etc...), However counting sick occurrences is proving tricky. The COUNTIF statement isn't the problem, its trying to get excel to understand what an occurrences is. If an employee calls in sick for three consecutive days, that is one occurrence. However if an employee calls in sick on Monday, back to work on Tuesday, calls in sick on Wednesday, back to work on Thursday, and calls in sick on Friday, that is 3 occurrences. How do I get excel to handle that?
Thank you for any help you can provide
Bookmarks