Hello everyone - first of all, thanks so much for the replies you've already posted here, so thankful for these! On the note of weekends, good question and so sorry to have not stated earlier, but the employees for which I am running this report are on shift work and can work weekends, so that is why I indicated I was looking to count any consecutive day, regardless of weekend/weekday.

I am running to meetings for the next few hours and will look into these solutions once I get a break in my schedule today - do appreciate your time!