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.

The example calendar shows October 8–11, 2026 and the two days counted with weekend code 7.

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.

Two single-day test tickets show Friday returning 0 and Sunday returning 1.

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.

Microsoft’s NETWORKDAYS.INTL reference.