Hi, I'm trying to write a formula to count consecutive days that an employee has called off to work that also bridges over vacation days and days off.

For example, I have an employee who calls in under "fmla" on Monday, was "scheduled off" on Tuesday, and then is "MIA" on Wednesday, the formula should see the fmla and mia segments as consecutive and ignore the day off that appears as either "day off", "holiday" or "vacation" in the cell for Tuesday.

I tried adding an or statement to the frequency function with no sucess, any ideas? Please help!