Weekdays, Saturday and Sunday non working days

[nparsons75]

Hi, I have this formula in my spreadsheet that makes Sunday a non working day. =IF(IFERROR(MATCH($C5,Holiday,0),0)=0,(IF(WEEKDAY($A5,2)=7,0,F$2)),0)

I also need to make Saturday a non working day, is this possible within this same formula?

 

[JamesCanale]

Maybe change:
IF(WEEKDAY($A5,2)=7
to
IF(WEEKDAY($A5,2)>5

 

[nparsons75]

Thank you, that seems to have done the trick