Generate a configurable month-end date series
Enter one spilling formula in E2. Return one horizontal row of exactly B4 numeric month-end dates: item i uses original B2 anchor and month offset B3 + i × B5, with i starting at zero. The first offset is signed; count is 1–12 and positive month step is 1–12. Clear all inactive cells within E2:P2 when a shorter series replaces a longer one. Anchor dates and every first/last target month stay within 1901–2099. Text/Boolean/blank/fractional inputs, zero count/step and out-of-bounds combinations remain unapplied. Preserve numeric dates and the format of future spill cells in copies.
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.
Make the formula your own.
View task requirements
Enter one spilling formula in E2. Return one horizontal row of exactly B4 numeric month-end dates: item i uses original B2 anchor and month offset B3 + i × B5, with i starting at zero. The first offset is signed; count is 1–12 and positive month step is 1–12. Clear all inactive cells within E2:P2 when a shorter series replaces a longer one. Anchor dates and every first/last target month stay within 1901–2099. Text/Boolean/blank/fractional inputs, zero count/step and out-of-bounds combinations remain unapplied. Preserve numeric dates and the format of future spill cells in copies.
No account. No upload. Just try it.