BUSINESS-DAY CALCULATION RECORD Original whole-date examples; Gregorian calendar, November 2026. Choose the controlling schedule first. The demonstration patterns are not country-wide rules. BLANK RULE RECORD Task and controlling organization: Schedule source, year and date checked: Effective start date and cutoff rule: Operation: inclusive range count / workday offset / other: End date or whole-number offset: Included endpoints and direction: Excluded weekdays (Monday through Sunday): Extra closure dates, scope and sources: Result and service-hour checks still needed: DAILY TRACE Date | Weekday | Scheduled workday? | Extra closure? | Included/skipped reason | Counter _____ | _____ | _____ | _____ | _____ | _____ _____ | _____ | _____ | _____ | _____ | _____ _____ | _____ | _____ | _____ | _____ | _____ _____ | _____ | _____ | _____ | _____ | _____ _____ | _____ | _____ | _____ | _____ | _____ _____ | _____ | _____ | _____ | _____ | _____ _____ | _____ | _____ | _____ | _____ | _____ _____ | _____ | _____ | _____ | _____ | _____ _____ | _____ | _____ | _____ | _____ | _____ _____ | _____ | _____ | _____ | _____ | _____ _____ | _____ | _____ | _____ | _____ | _____ _____ | _____ | _____ | _____ | _____ | _____ MONDAY-FIRST WEEKEND STRINGS 0 = working weekday; 1 = nonworkday. Saturday/Sunday: 0000011 Friday/Saturday: 0000110 Sunday only: 0000001 Friday/Saturday/Sunday: 0000111 ORIGINAL TRACE: ADD FOUR AFTER 2 NOVEMBER, EXCLUDE THE START Date | Saturday/Sunday off | Friday/Saturday off Mon 2 Nov | Start; not counted | Start; not counted Tue 3 Nov | Workday 1 | Workday 1 Wed 4 Nov | Workday 2 | Workday 2 Thu 5 Nov | Workday 3 | Workday 3 Fri 6 Nov | Workday 4 — result | Weekend; skip Sat 7 Nov | Weekend; skip | Weekend; skip Sun 8 Nov | Weekend; skip | Workday 4 — result Mon 9 Nov | Workday 5 | Workday 5 Tue 10 Nov | Workday 6 | Workday 6 EIGHT PRACTICE QUESTIONS Case 1: An invented organization excludes Friday and Saturday. Starting on Thursday, 5 November 2026, what date is one workday later if the start is excluded and there are no extra closures? Your included/skipped dates and answer: Case 2: Count both endpoints from Monday, 2 November through Friday, 6 November 2026. No extra closures apply. How many working dates are there under each two-day weekend? Your included/skipped dates and answer: Case 3: From Monday, 2 November 2026, add four workdays, excluding the start and using no extra closures. Compare the two weekend patterns. Your included/skipped dates and answer: Case 4: The inclusive range is Thursday, 5 November through Monday, 9 November 2026. Both weekend patterns give three workdays with no extra closures. Does that prove the masks are interchangeable? Your included/skipped dates and answer: Case 5: Your invented organization has an extra closure on Friday, 6 November 2026. Count 2–8 November inclusively. Does adding this closure reduce the result under both weekend patterns? Your included/skipped dates and answer: Case 6: Start on Thursday, 5 November 2026 and add two workdays, excluding the start. The invented organization also closes on Monday, 9 November. What result do the two weekend patterns give? Your included/skipped dates and answer: Case 7: What does Excel WORKDAY.INTL return for a zero offset from Saturday, 7 November 2026? Does the result establish that Saturday is open? Your included/skipped dates and answer: Case 8: An invented joint task can occur only when both teams are working. Team A excludes Saturday/Sunday; Team B excludes Friday/Saturday. No other closures apply. From Thursday, 5 November 2026, what is their first common workday after the start? Your included/skipped dates and answer: ANSWERS AND EXPLANATIONS Case 1: Sunday, 8 November 2026. Friday 6 and Saturday 7 are nonworkdays under this chosen calendar. Sunday 8 is the first included date after Thursday. A Saturday/Sunday default would instead return Friday 6. Case 2: Five with Saturday/Sunday off; four with Friday/Saturday off. The inclusive range has five dates. Monday through Thursday count in both calendars. Friday counts only in the Saturday/Sunday calendar. The count is not the number of elapsed nights or an offset from Monday. Case 3: Friday, 6 November with Saturday/Sunday off; Sunday, 8 November with Friday/Saturday off. Tuesday, Wednesday and Thursday are the first three workdays after Monday in both patterns. The fourth is Friday in the first calendar and Sunday in the second. The daily trace makes the two skipped dates visible. Case 4: No. The counts match, but one includes Friday and the other includes Sunday. Saturday/Sunday off counts Thursday 5, Friday 6 and Monday 9. Friday/Saturday off counts Thursday 5, Sunday 8 and Monday 9. Equal totals can conceal different operational dates. Case 5: It reduces the Saturday/Sunday result from five to four; the Friday/Saturday result remains five. Friday was a working date in the first pattern and already a weekend date in the second. A date that is already excluded cannot remove another working date. This is a fictional closure, not an announced public holiday. Case 6: Tuesday, 10 November 2026 in both patterns. The first included date is Friday 6 under Saturday/Sunday off and Sunday 8 under Friday/Saturday off. Monday 9 is excluded by the additional closure. Tuesday 10 is the second included date in either trace. Case 7: It returns the specified start date, 7 November; that does not establish an open day. Microsoft documents zero as returning the already specified start date. Moving a nonworking date to the next working date is a separate operation with its own rule. Do not use a zero offset as an opening-hours check. Case 8: Monday, 9 November 2026. Friday is unavailable to Team B, Saturday to both, and Sunday to Team A. Their common working weekdays are Monday through Thursday. This assumes both teams must be available; a real service may define a different controlling calendar. SOURCE REFERENCES Microsoft Support: NETWORKDAYS.INTL https://support.microsoft.com/en-us/excel/functions/networkdays-intl-function Microsoft Support: WORKDAY.INTL https://support.microsoft.com/en-us/excel/functions/workday-intl-function OPM: Federal Holidays — “In Lieu Of” Determination https://www.opm.gov/policy-data-oversight/pay-leave/work-schedules/fact-sheets/Federal-Holidays-In-Lieu-Of-Determination