You have the reading room from Monday June 8 through Friday June 12, 2026. It is closed on Wednesday. Before scheduling a volunteer for each available day, check how many shifts the date range actually holds.

Put the dates and the closure in separate cells

Enter June 8 in A2, June 12 in B2 and June 10 in E2, all in 2026. Use date cells so the workbook interprets each value as a date. In a blank cell enter:

=NETWORKDAYS(A2,B2,E2)

The result is 4. Monday, Tuesday, Thursday and Friday count. With this function, Saturday and Sunday are already weekends, and E2 supplies the additional closure.

June 8, 9, 11 and 12 count as workdays. June 10 is a closure.

Illustrated planning week. Enter the closure as a date in its own cell.

Check the boundaries before copying the formula

Try =NETWORKDAYS(A2,B2) to check that the full week is five days. Try =NETWORKDAYS(A2,A2) to check that the start day counts. It should return 1. If you fill down a column for other date windows, use a fixed range such as $E$2:$E$20 for the shared closure dates. Compare the weekend rule with the real rota before planning a team that normally works Saturday.

The whole week without the closure gives five, and Monday on its own gives one.

Illustrated cross-check. Both ends of the range are eligible to count.

Microsoft’s NETWORKDAYS reference