Hi all,
I have a formula that is counting Saturdays for me. The formula is: =SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A18&":"&B18)))=7))
This is working well for me with one exception. I need it to NOT count the holidays that land on Saturday. I have a list of the holidays that I don't want it to count but I'm not sure how to put it into this formula.
I want something similar to this:
=NETWORKDAYS(A18,B18,'Holiday Dates'!A5:A34)
but for Satudays.
Thanks in advance
BJ
I have a formula that is counting Saturdays for me. The formula is: =SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A18&":"&B18)))=7))
This is working well for me with one exception. I need it to NOT count the holidays that land on Saturday. I have a list of the holidays that I don't want it to count but I'm not sure how to put it into this formula.
I want something similar to this:
=NETWORKDAYS(A18,B18,'Holiday Dates'!A5:A34)
but for Satudays.
Thanks in advance
BJ