Choose a working cutoff at month end
Your goal: Shift to a target month, locate its calendar end, then move backward to the final eligible date.
Full task requirements
Fill C2:C5 with the final eligible working date on or before the last calendar date of the month reached by shifting the date in column A by the whole-month offset in column B. Use the text weekly mask G2 and office-closure list G4:G7.
Weekend month ends and a shifted yearRead 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.