Count Public Holidays that falls on a Saturday

[cloud2828]

I have a list of public holidays and I would like to know how I could count the ones that fall on a satuday.

 

[cloud2828]

I'm experiencing a new issue, the list of public holidays has space to enter more data thus those spaces are being counted also, is there a way to prevent this without removing the blank spaces in my table?

 

[Joe4]

I'm experiencing a new issue, the list of public holidays has space to enter more data thus those spaces are being counted also, is there a way to prevent this without removing the blank spaces in my table?

Just check to see if it is also greater than zero (dates are stored as numbers):
=SUMPRODUCT(--(WEEKDAY(A2:A32)=7),--(A2:A32>0))

 

[cloud2828]

Also, is it possible to count this for each month of the year?

 

[cloud2828]

Just check to see if it is also greater than zero (dates are stored as numbers):
=SUMPRODUCT(--(WEEKDAY(A2:A32)=7)--(A2:A32>0))

This unfortunately didn't work, it still counts the blank spaces. Is this because a blank space is counted as a number?

 

[Joe4]

Also, is it possible to count this for each month of the year?

Try:
=SUMPRODUCT(--(WEEKDAY(A2:A32)=7),--(A2:A32>0),--(MONTH(A2:A32)=7))
(change the number in red to the month number you want to check for)

 

[Joe4]

This unfortunately didn't work, it still counts the blank spaces. Is this because a blank space is counted as a number?

I had a typo and missed a comma. I have amended the formula.

 

[cloud2828]

I had a typo and missed a comma. I have amended the formula.

Okay thanks, this works perfect!

 

[Fluff]

Another option
=SUMPRODUCT((WEEKDAY($A$2:$A$31)=7)*($A$2:$A$31>0)*(MONTH($A$2:$A$31)=ROWS($A$1:$A1)))
& drag down to fill 12 cells & it will give the count for successive months

 

[cloud2828]

Another option
=SUMPRODUCT((WEEKDAY($A$2:$A$31)=7)*($A$2:$A$31>0)*(MONTH($A$2:$A$31)=ROWS($A$1:$A1)))
& drag down to fill 12 cells & it will give the count for successive months

Saw this after I finished manually typing in the months.