What if the range doesn't divide evenly?

The split is done in milliseconds and each boundary is snapped to the nearest midnight, so the last interval may run a day longer or shorter than the others. The intervals are still as balanced as whole-day output allows.

Why would I pick Boundaries over Intervals?

Boundaries are exactly the cut-points you'd feed into a `BETWEEN` query or a partitioning function — no start/end pairing needed.

Date Range Splitter

Time

Useful for chunked reports, sprint planning, monthly cohorts, batch jobs, or anything that needs a long span divided into equal slices. Intervals mode lists the start, end, and length in days for each chunk; Boundaries mode lists just the N+1 cut-points (handy as input for downstream queries).

—

StartEndIntervals

Output:

Include end date

Splits

#12026-06-02 → 2026-09-0191d
#22026-09-01 → 2026-12-0292d
#32026-12-02 → 2027-03-0391d
#42027-03-03 → 2027-06-0392d

Boundaries are snapped to midnight in your local timezone.

How to use

Pick start and end dates and how many intervals you want (up to 50).
Toggle between Intervals and Boundaries depending on what your script needs.
Inclusive end keeps the last day inside the range; turn it off for half-open `[start, end)` style.

Frequently asked questions

What if the range doesn't divide evenly?: The split is done in milliseconds and each boundary is snapped to the nearest midnight, so the last interval may run a day longer or shorter than the others. The intervals are still as balanced as whole-day output allows.
Why would I pick Boundaries over Intervals?: Boundaries are exactly the cut-points you'd feed into a `BETWEEN` query or a partitioning function — no start/end pairing needed.