Skip to main content
← All challenges

Schedule dates with a working calendar

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.

The answer cells begin blank. Enter a reusable formula and check it against the published practice datasets. Hints and the solution are available when you choose them.

Practice stays on this device. No worksheet data is uploaded.

A checkpoint records a fresh check of every dataset. This attempt tracks built-in hints, solutions, steps and worked examples; it does not establish independent authorship.

Help recorded: none of these built-in aids opened.

A LITTLE PRACTICE

Make the formula your own.

View 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.

Runs in your browser

No account. No upload. Just try it.

Read the full explanation →