Count cells if weekends
|
Range Reference:
|
|
Number representing Saturday:
enter the cell reference that captures the value that represents the first day of the weekend (Saturday) that corresponds to the return type |
|
Formula:
|
=SUMPRODUCT(--(WEEKDAY(B8:B14,2)>=C5))
=SUMPRODUCT(--(WEEKDAY(B8:B14,2)>=C5))