Random Date Generator (YYYY-MM-DD)

Random dates output as YYYY-MM-DD, ready to paste into databases, spreadsheets, JSON fixtures and test scripts. Nothing is excluded by default; tick the options to skip weekends or holidays.

Settings

Start date

End date

How many dates Exclude weekends

Saturday Sunday Friday Monday

Exclude public holidays Country

Custom dates to exclude (one per line — 2026-12-24, 12/24/2026, or 12-24 for every year)

Output options

Date format

Seed (optional, for repeatable results)

Show weekday No duplicates Sort chronologically

Result

Holiday rules version . National / federal holidays only — add regional or company days in the custom box. Everything runs in your browser; nothing is uploaded.

ISO dates for developers and testers

This page is the plain-format version of the generator: every result is a zero-padded YYYY-MM-DD string, which sorts correctly as text, parses in every language, and is what SQL DATE columns, JSON APIs and CSV imports expect. Ask for ten or a thousand dates, copy them as a list, as CSV or as a JSON array with the ISO string, and the weekday name.

Repeatable random data

Enter a seed and the same settings always produce the same list — handy for fixtures that must not change between test runs. Turn "No duplicates" off if you want sampling with replacement.

Constrained dates

Need only working days, for due dates or timestamps that should look realistic? Tick the weekend days and enable public holidays for the US, UK, Canada, Australia or Germany. The random date generator excluding weekends and holidays has those switched on by default.

Frequently asked questions

Is the output really ISO 8601?

Yes — YYYY-MM-DD with zero padding, for example 2026-03-07. The JSON export also includes the weekday.

Can I generate random datetimes?

Not yet; this tool produces calendar dates. A random time generator is planned.

How many dates can I generate at once?

Up to 1,000 per run within a 50-year range.