Random Date Generator

Pick a random date between two dates, or generate up to 10,000 at once. Limit the results to weekdays, weekends or any days of the week, add random times, prevent duplicates, sort them, and choose a format: ISO (2026-03-14), US (03/14/2026), European (14/03/2026), a long written date or a Unix timestamp. It's handy for test data, spreadsheets, random event scheduling, writing prompts, games and date-of-birth samples.

  • 100% free
  • No sign-up
  • Private & local
  • Works on mobile
Ranges:

Days of the week

Private by design: every calculation runs locally in your browser. Nothing you type is sent to a server or stored by us.

How to Generate Random Dates

  1. Set the date range. Both the start and end dates can be picked. Use a quick range button for common choices.
  2. Choose how many dates you need, from 1 to 10,000.
  3. Filter the days of the week, for example weekdays only for business dates, or weekends only for events.
  4. Pick a format and order, and whether to include a random time of day.
  5. Copy or download the list and paste it into your spreadsheet, database or document.

Date Formats Explained

FormatExampleBest for
ISO 86012026-03-14Databases, programming, sorting as text, international use
US03/14/2026US spreadsheets and forms (month first)
European14/03/2026UK, Europe, India, Australia (day first)
Dotted14.03.2026Germany, Switzerland, Austria, Russia
LongSaturday, March 14, 2026Documents and writing, in your browser's language
Unix timestamp1773446400Programming: seconds since 1 January 1970 (UTC)

Be careful when mixing formats: 04/05/2026 is 5 April in the US but 4 May in most other countries. When in doubt, the unambiguous ISO format is the safest choice, and spreadsheets like Excel and Google Sheets recognise it everywhere.

Uses for Random Dates

  • Test data: realistic order dates, sign-up dates or birthdays for software testing and demos.
  • Spreadsheets and training: sample data for teaching Excel, SQL or data analysis.
  • Scheduling: random audit, inspection or spot-check dates that people can't predict.
  • Research: random sampling of days from a period for surveys or record reviews.
  • Fun and creativity: history quiz questions, "on this day" challenges, writing prompts and game events.

How It Works

The generator converts both dates to day numbers, then picks whole days uniformly at random using your browser's secure random number generator. Every allowed date in the range has exactly the same chance of being chosen, and leap years, month lengths and time zones are all handled correctly because the calculations use UTC calendar days. When "No duplicate dates" is ticked, dates are drawn without replacement. If you ask for more unique dates than exist in the range, you get every matching date instead. Random times are picked to the second, from 00:00:00 to 23:59:59.

Weekdays Only and Other Filters

The day-of-week filter lets you create business-day samples (Monday to Friday), weekend dates, or any combination, such as only Tuesdays and Thursdays for a class timetable. The tool shows how many possible dates match your range and filters, which is useful for checking that a sample is large enough. Public holidays aren't excluded automatically, so remove any that matter to you after generating.

Random Dates for Spreadsheets and Databases

Generating realistic dates is one of the most common tasks when building test data. Choose the ISO format for databases and programming languages, because it sorts correctly as text and is understood by SQL, Python, JavaScript and most other systems. For Excel or Google Sheets, pick the format that matches your spreadsheet's regional settings, so the dates are recognised as real dates rather than text. After pasting, you can format the cells however you like. If you need dates with times, tick "Include a random time" and choose ISO for values like 2026-03-14T09:26:53.

Unix timestamps count the seconds since 00:00 UTC on 1 January 1970 and are used in many APIs, log files and databases. They're plain numbers, which makes them easy to compare and store.

Picking Random Days Fairly

Random dates are also useful when a choice must be unpredictable and fair, such as unannounced fire drills, quality checks, prize draw dates or random audits. Because every eligible day has exactly the same chance, nobody can predict or influence the result. For recurring checks, generate a list of unique dates for the year in one go, sort them oldest first, and add them to your calendar.

Frequently Asked Questions

Are the start and end dates included?

Yes. Both dates can be chosen, as long as they match the day-of-week filter.

Can I generate random birthdays?

Yes. Use the "Adult birth dates" range, which covers people aged about 18 to 80, or set your own.

How do I get only weekdays?

Click the Weekdays button, or untick Saturday and Sunday.

What time zone are the times in?

Dates and times are generated as plain calendar values (UTC for Unix timestamps), so they don't shift with your time zone.

How many dates can I generate?

Up to 10,000 per click.