Random Anvil

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

Holiday coverage and sources

National or federal rules only. UK means England and Wales. Regional, company and exceptional holidays may differ; add those in the custom box. This is a recurring-rule calculator, not a complete historical holiday archive.

Official references: US federal holidays · UK bank holidays · Australia by state and territory · Canada federal general holidays · Germany holiday calendar. Reference links checked October 14, 2026; this does not certify every historical or future date.

For Canada, this calculator uses next-weekday substitutes as a planning convention; employer schedules may use a different day.

Output options

Result

Holiday rules version . National / federal holidays only — add regional or company days in the custom box. Calculations run in your browser. Shared URLs include your settings; see the privacy page.

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 with working-day settings opens with those filters enabled.

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.

All date tools on this site

Random dates

Business days

Recurring dates