Dates & time

Merge date ranges

Combine overlapping inclusive date ranges without double-counting covered days.

Merge date ranges
Esc to restore

Your inputs

Up to 25 MB per file, 50,000 data rows, 200 columns and 2 million data cells. Fully blank rows and columns are ignored before row, column and cell limits are checked. Individual tools may have smaller result or chart limits.

Results update as you type. Larger files run when you press Update result.

Processed on your device

Your result

LOCAL & PRIVATE

Your result will appear here.

Your inputs stay in this browser. Nothing is uploaded or saved.

A clear answer. Here’s how.

Sorts up to 10,000 inclusive date ranges and merges overlaps. Optionally merges ranges ending immediately before the next range starts. Reports merged boundaries, each inclusive day count and total distinct coverage. Requires exact Start,End headings and valid ordered dates. Your input order is not retained.

See a worked example

Worked example

A fixed demonstration, separate from the values you enter above.

CSV: Start,End
Start,End
2026-10-01,2026-10-05
2026-10-04,2026-10-08
2026-10-12,2026-10-14
Adjacent ranges
Combine consecutive dates too

Example result

Example result
StartEnd (included)Covered days
2026-10-012026-10-088
2026-10-122026-10-143

3 input ranges → 2 merged ranges.

Keep going.

Date differenceDate range generatorRecurring date plannerNth weekday of a month