Column G has working days
=WORKDAY.INTL($G2,1,"0001110")
Column H has non-working days indicated by "X" in column
=IF(COUNTIF(E:E,G3),"","X")
Filter on Column H
NOTE: no holidays considered
Or in column F
=IFERROR(INDEX(G:G,SMALL(IF($H$3:$H$200="x",ROW($H$3:$H$200)),ROWS($1:1))),"")
enter with Ctrl+Shift+Enter
Bookmarks