Schedule dates with a working calendar
Your goal: Move forward or backward by working days, with a configurable weekend and a separate office-closure list.
Full task requirements
Fill C2:C5 with each date reached after the working-day offset in column B, starting from column A. Use the Monday-first text weekend mask in G2 and the closure dates in G4:G7. Do not count the starting date when moving; a zero offset returns that original date even when it is closed.
Weekend, zero and backward offsetsRead the shared working calendar
Dates are displayed as calendar dates but remain numbers. Choose source cells, then reason about the stated calendar policy.
| # | |||
|---|---|---|---|
| 1 | |||
| 2 | |||
| 3 | |||
| 4 | |||
| 5 | |||
| 6 | |||
| 7 |
Step 1 of 5
Read the shared working calendar
Rules for this step
The seven-character mask starts with Monday. A 1 closes that weekday; a 0 allows it. Actual closure dates close otherwise eligible days once, even when repeated.