Solved: Count weekly offs based on day of week

[lynnnow]

Hi,

Please see the attachment.

I've got people with weekly offs on Mondays or Saturdays (I've not posted all the data, but will update the formula with the solution provided). The Sunday weekly offs are not supposed to be counted. This has to be counted from the 21st of the previous month to the 20 of the current month.

Is there a way to check the day of week for a particular row and count the number of WO (Saturday or Monday) in total that are extra?

I've never used an array formula and don't know how to go about it.

Please advise.

[Bob Phillips]

Try

=SUMPRODUCT(($C4:$L4="WO")*(WEEKDAY($C$3:$L$3)={2;7}))

(not an array formula)

[lynnnow]

Thanks xld. I did a formula audit to understand the formula. It works gr8.

Lincoln :wavey: