Hi! I am stuck trying to add weekends in which the people on my team are OFF(NOT WORKING). But I have tried this formula =SUMPRODUCT((WEEKDAY($E$2:$A$O4,2)>5)*(E23:AQ23="OFF")) But the problem is that sometimes we have split days as OFF so it is not the complete weekend is there a way that I can count only when both days of the weekend are OFF. Thank you!!
Bookmarks