Counting weekend days in a particular month

[nsamuels]

I am trying to count how many Saturdays and how many Sundays are in a particular month. I do not have a start date or end date but I used the following formula =NETWORKDAYS(B296-DAY(B296)+1,EOMONTH(B296,0), $U$2:$U$22) to calculate the work days in the particular month. Is there a formula like the one the I just noted to calculate the weekend day?

 

[Jonmo1]

If you already have a formula that counts the weekdays....
Then you get the count of weekENDs, then it's just TotalDays-weekdays.
So you really only need to know the total # of days in the month (28 29 30 or 31)
This will give you that number
=DAY(EOMONTH(B296,0))

So if say A1 has your formula that counts how many workdays there are.
Then this will tell you how many Weekend days there are.
=DAY(EOMONTH(B296,0))-A1

 

[nsamuels]

How do I exclude holiday's. For example, when I put the formula into a 01/01/2016 date it came back as 11 weekends and it was only 10. So I am assuming that it was pulling a holiday. Also, is there a way to separate the count for Saturday and Sunday.

 

[chicagocomputerclasses]

=NETWORKDAYS.INTL(start_date, end_date, "1111100", [holidays range])

 

[nsamuels]

Is there a way to specify how many Sundays in a particular month and how many Saturdays in a particular month?

 

[Jonmo1]

Yes, it was counting Saturdays Sundays and Holidays as one group.
So I was only considering 2 possible states for any given day. Either it's a Working Day, or it's NOT a working day.

Post #4 shows a good method if you have XL2010+ and want to strictly only count saturday and sunday (not holidays)

 

[chicagocomputerclasses]

"1111100" is a 7 day string starting Monday. 1 means don't count it, 0 means count the day.
"1111101" would just count Saturdays.

As Jonmo1 mentioned above, this will work only in Excel 2010 & above