Count Weekend Days solutions thank you very much to both of you

D

Domenic

To count the number of Saturdays and Sundays...

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A2&":"&B2)),2)>5))

....where A2 contains the start date, and B2 contains the end date.

Hope this helps!

koob <[email protected]> wrote:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count the remaining weekdays in a data range excluding holidays and start/end dates 5
Sumproduct with weekend day test 4
Counting Mondays in Date Range 5
Formula to get number of days excluding Fridays in a given period 17
Counting occurences of a specific day between two dates 1
Count number of days between dates BUT IF null to current date 1
I want to count days between two dates including start date 2
Count no. of occurance in 2 dynamic columns within a data period 7

Top