Date Range Generator

How to use

1. 1Pick a start date and an end date. Both endpoints are inclusive.
2. 2Choose a step: every day, weekdays only, every N days, weekly on chosen days, monthly on a day of month, or yearly.
3. 3If you need to skip specific dates, paste a holiday list one date per line in YYYY-MM-DD format.
4. 4Pick an output format, separator, and optional prefix and suffix so the list pastes straight into SQL, Markdown, or a spreadsheet.
5. 5Copy the list, download .txt for plain output, or download .csv for a table with weekday and day-of-year columns.

About this tool

Date Range Generator lists every date between a start and end date you choose, using whatever step makes sense for the job. The default daily step produces a continuous run of calendar days inclusive on both ends, useful for filling gaps in a spreadsheet or building a stand-up rotation. Weekdays only skips Saturday and Sunday so a 90-day window collapses to working days. Every N days steps by a fixed count (7 for weekly, 14 for bi-weekly, 30 for roughly monthly) anchored to the start date. Weekly on chosen days lets you pick any combination of weekdays, so a Monday-Wednesday-Friday class schedule or a Friday-Saturday-Sunday weekend shift list comes out in one click. Monthly on a day of month emits the same date each month with a clear policy for short months: clamp to the last day (Jan 31 then Feb 28), skip the month entirely, or roll forward to the next month with the day. Yearly emits the same MM-DD each year and clamps Feb 29 to Feb 28 in non-leap years so the sequence never drops a row by accident. An optional holidays list (paste one YYYY-MM-DD per line) removes specific dates from the output without changing the step. Output formats cover ISO 8601 (YYYY-MM-DD), US slash (MM/DD/YYYY), EU slash (DD/MM/YYYY), long and short English, ISO with weekday, Unix seconds, Unix milliseconds, a SQL DATE literal ('YYYY-MM-DD'), and a custom token format using YYYY, MM, DD, dddd, Q, and the other tokens already used by the random date generator. Separators include newline, comma plus space, semicolon plus space, and single space, and the optional prefix and suffix wrap each row so the list pastes straight into a SQL IN clause, an INSERT statement, or a YAML schedule. Copy buttons, plain text download, and CSV download (with weekday and day-of-year columns) are all available. Useful for stand-up rotations, on-call schedules, content calendars, recurring billing dates, fixture data for tests, anchor dates in a SQL query, payment plan tables, anniversary lists, and any situation where you need every date that matches a rule between two endpoints. Output is capped at 10,000 rows to keep the page responsive; everything is computed in your browser and nothing is uploaded.

Free to use. Works in your browser. No signup, no login.