Date Range Splitter
Split any date range into weekly, monthly, or quarterly chunks with day counts for reporting periods, invoicing, and sprint planning.
Loading tool...
What is Date Range Splitter?
Date Range Splitter is a free online tool that breaks any date range into consecutive, calendar-aligned periods. Choose weekly (Monday-Sunday), monthly, or quarterly splits and get every chunk's start date, end date, and day count in a clean table you can copy as CSV — perfect for reporting periods, invoicing cycles, and sprint planning.
Key Benefits
- Periods align with real calendar boundaries, not arbitrary day counts
- Per-period day counts make prorated billing and timesheets painless
- Partial first and last periods are handled automatically
- CSV export drops straight into Excel, Google Sheets, or BI tools
- Fully offline — your dates never leave the browser
Common Use Cases
- •Splitting a quarter into weekly sprint windows for an agile board
- •Creating monthly billing periods for a mid-month project kickoff
- •Preparing week-by-week attendance or timesheet templates
- •Breaking a marketing campaign into weekly reporting chunks
- •Dividing a lease or contract term into calendar quarters
How to Use Date Range Splitter
- Pick the start and end dates: Choose the range you want to split — for example a project timeline, a billing cycle, or a quarter you are reporting on.
- Choose a split mode: Select Weekly for Monday-Sunday chunks, Monthly for calendar months, or Quarterly for Q1-Q4 boundaries.
- Click Split Range: The tool lists every period with its start date, end date, and day count. Partial first and last periods are handled automatically.
- Copy or download the results: Use Copy CSV to paste into a spreadsheet, Copy as text for notes and emails, or download a .csv file for your records.
Key Features
- Weekly, monthly, and quarterly split modes with one click
- Calendar-aligned boundaries: ISO Monday-Sunday weeks, calendar months, and Q1-Q4 quarters
- Day count per chunk for prorated invoices, timesheets, and burn-down math
- Copy as CSV or plain text, or download a ready-to-open .csv file
- Handles partial first and last periods automatically — no manual trimming
Frequently Asked Questions
How does the weekly mode align weeks?
Weekly mode uses ISO-8601 style weeks that run Monday through Sunday. The first chunk starts on your start date and ends on the first Sunday it reaches; the last chunk ends on your end date, so partial weeks at both ends are counted correctly.
What happens if my range starts mid-month or mid-quarter?
Nothing breaks — the tool simply creates partial periods. A range from March 15 to June 10 in monthly mode yields Mar 15-31, the full months of April and May, and June 1-10, each with its own accurate day count.
How is the day count of each period calculated?
Each period shows the inclusive number of calendar days from its start date to its end date. Both boundary dates are counted, and the day counts of all periods always add up to the total days in your range.
Can I use the output for invoicing or billing periods?
Yes. The CSV output (index, label, start, end, days) imports cleanly into Excel or Google Sheets, and the per-period day count makes prorated billing straightforward — just multiply your daily rate by the days column.
Does this tool handle leap years and year boundaries?
Yes. All math uses real calendar dates via the JavaScript date engine, so February 29 is included in leap years and ranges crossing December 31 split correctly into the next year's months and quarters.