Need to count consecutive weekday absences

[dms11463]

Hello - I need assistance with a formula to count the consecutive number of weekdays an employee is absent, even when it crosses calendar weeks. Example, if an employee is out Thursday/Friday of one week, then Monday/Tuesday of the next, the count would need to be 4.

My full file will have over 50,000 lines of data, so manually counting this is too cumbersome.

 

[Fluff]

Duplicate to: Seeking Formula help to count consecutive weekday absences

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.