Calculate Number of Weekend Days That Passed in Current Month

[welshraz]

Hello!

I have a formula that shows me the number of workdays that have passed for the current month - =NETWORKDAYS((EOMONTH(TODAY(),-1)+1),TODAY()-1)

I need a similar formula that calculates the same but for weekend days (Saturday and Sunday). I can't seem to find anything that specifically works for weekend days only.

Thanks.

 

[welshgasman]

Can't you just subtract that from the number of days so far?

 

[Fluff]

How about

=NETWORKDAYS.INTL(EOMONTH(TODAY(),-1)+1,TODAY()-1,"1111100")