Forum Discussion
Help with a formula
I am setting up a spreadsheet and I am trying to count the days of the month as either weekdays or weekends. In the column, I have the running dates, but I will be erasing some of them as we are not...
In Excel day 1 is Sun 1st Jan 1900 so day 0 is a Saturday. To remove the blanks from your weekend formula you could use
=SUMPRODUCT((date<>"")*(WEEKDAY(date,2)>=6))
or with dynamic arrays
= SUM(IF(date<>"", SIGN(WEEKDAY(date,2)>=6)))