Date Range Generator

Generate a list of all dates between a start and end date at once.

Category: Date & Time

When to use?

Use it to create a list of dates in one go for spreadsheets, CSV, or development test data.

How to use

  • Enter a start and end date.
  • Choose the interval and whether to include weekends.
  • Pick a delimiter and copy the date list.

Input Explanation

The interval is a whole number of days, up to 365. The result list is capped at 1,000 entries.

Calculation Basis

It steps from the start to the end date by the chosen day interval, generating date strings. If the end is earlier, it can produce a reverse-order list.

Usage Examples

  • Generate an Excel date column - Build a date list to paste in without repetitive typing.
  • Prepare test data - Generate continuous date data for development testing at once.
  • Draft a schedule - List every date in a period to build the skeleton of a schedule or checklist.

Examples

  • 2026-05-13 to 2026-05-15 → 2026-05-13, 2026-05-14, 2026-05-15
  • 2026-05-01 to 2026-05-31, 7-day interval → 05-01, 05-08, 05-15, 05-22, 05-29

Cautions

  • A very long range can slow the browser or run low on memory.
  • Time-zone settings can cause a one-day difference in some cases.

FAQ

Can I exclude weekends?

Yes. Turn off "include weekends" to exclude Saturdays and Sundays.

Can I change the date format?

Copy the generated list and reformat it in a spreadsheet or editor.

Can the range be long?

Long ranges generate, but a very long list can slow down the display.

What if start and end are the same?

Only that single date appears in the list.

Related Tools