Count cells if weekdays

Macro Title:

Worksheet Variable:

Worksheet Name:

Range Reference:

Weekday:

Output Cell:

First Comment:

Second Comment:

Sub Count_cells_if_weekdays()

'declare a variable
Dim ws As Worksheet

Set ws = Worksheets("Analysis")

'apply the formula to count cells if weekdays
ws.Range("F8").Formula = "=SUMPRODUCT(--(WEEKDAY(B8:B14,2)<=C5))"

End Sub

Sub Count_cells_if_weekdays()

'declare a variable

Dim ws As Worksheet

Set ws = Worksheets("Analysis")

'apply the formula to count cells if weekdays

ws.Range("F8").Formula = "=SUMPRODUCT(--(WEEKDAY(B8:B14,2)<=C5))"

End Sub

Sub Count_cells_if_weekdays()

'declare a variable
Dim ws As Worksheet

Set ws = Worksheets("Analysis")

'apply the formula to count cells if weekdays
ws.Range("F8").Formula = "=SUMPRODUCT(--(WEEKDAY(B8:B14,2)<=C5))"

End Sub