The booking desk works Sunday through Thursday. A request runs from Thursday 8 October through Sunday 11 October 2026. The default weekend would count the wrong dates and could still return the same total.
Specify the desk’s actual weekend
Put 8 October 2026 in B2 and 11 October 2026 in C2 as date values. In D2, enter =NETWORKDAYS.INTL(B2,C2,7). Weekend code 7 marks Friday and Saturday as nonworking days. The inclusive interval should contain two workdays, Thursday and Sunday.

Example interval. The count includes both endpoint dates when they are workdays.
Test Friday and Sunday separately
In a copy, enter the Friday date in both input cells and expect zero. Enter the Sunday date in both and expect one. These checks catch a weekend error that can hide in the four-day total.

Example weekday checks. A total of two alone cannot tell you which two dates were counted.
If a closure falls on a working day, enter its date in a holiday range such as F2:F6 and add that range as the fourth argument. With Sunday 11 October in that range, the original interval would have one workday. Label the workbook with the desk schedule it uses.



