If the weekend is still 2 consecutive days it's relatively easy to modify NETWORKDAYS, e.g. for Fri/Sat
=NETWORKDAYS(A2+1,B2+1)
or to handle a holiday range in H2:H10
=NETWORKDAYS(A2+1,B2+1,INDEX(H$2:H$10+1,0))
for Thu/Fri change the +1s to +2s, for Wed/Thu use +3 etc....
For single weekend day you can use a formula like this
=B2-A2+1-INT((WEEKDAY(A2-6)+B2-A2)/7)
That excludes just Friday - change the 6 for other single days (1 = Sun to 7 = Sat)
If you need to exclude holidays from the latter version then it needs a further tweak......
Bookmarks