How to use the date range chunker
- Enter the first day and the last day of the range. The last day is included.
- Choose how to cut it: weeks, calendar months, calendar quarters or chunks of a set length.
- For weeks, choose the weekday the week starts on. For a set length, enter the number of days.
- Read the chunk list and download it as CSV.
Formula
weeks: a chunk ends on the day before the next chosen start weekday
months and quarters: a chunk ends on the last day of the calendar month or quarter
set length: a chunk ends after the chosen number of days
the last chunk is cut off at the last day of the range
The first and last chunks can be shorter than the rest because they follow your dates. Chunks never overlap and leave no gaps, so their lengths add up to the whole range.
Ten weeks, six months and every 14 days
From Monday, January 5, 2026 to Sunday, March 15, 2026 is 70 days. Cut into weeks that start on Monday, it gives 10 chunks of 7 days each, the first from Mon Jan 5 to Sun Jan 11. Cut into chunks of 14 days it gives 5 chunks.
From January 15 to June 10, 2026, which is 147 days, calendar months give 6 chunks: January 15 to 31 (17 days), February (28), March (31), April (30), May (31) and June 1 to 10 (10 days).
Uses for chunked dates
Splitting a range helps when a report or request must cover a long period in smaller pieces, such as pulling data a week at a time, billing by month or scheduling work in sprints. The start and end of every chunk are listed, so you can paste them into a query or a calendar.
The week start matters. A week that starts on Sunday and one that starts on Monday cut the same range into different pieces, and the first and last pieces change length.
Related date tools
To make a repeating list of dates instead, use the Date Sequence Generator. To count the days between two dates, use Days Between Dates. To find which week of the year a chunk starts in, use the Week Number Calculator, and to move a date by days or months, use the Date Calculator.
Assumptions and limits
- Both the first day and the last day are included in the range.
- Months and quarters follow the Gregorian calendar, with quarters starting in January, April, July and October.
- At most 400 chunks are produced.
- The dates shown when the page opens are examples.
Frequently asked questions
Why is my first chunk shorter than seven days?
When the range starts in the middle of a week, the first chunk runs only to the end of that week. The same is true for months and quarters.
Is the last day included?
Yes. The last chunk ends on the last day you entered, and that day is counted in its length.
What is the longest range I can use?
There is no fixed number of days, but the result is limited to 400 chunks. Use longer chunks for very long ranges.
Can I start the week on Saturday?
Yes. The week start list has all seven weekdays, so you can match a workweek that starts on any day.