How to Generate Random Dates
- Set the date range. Both the start and end dates can be picked. Use a quick range button for common choices.
- Choose how many dates you need, from 1 to 10,000.
- Filter the days of the week, for example weekdays only for business dates, or weekends only for events.
- Pick a format and order, and whether to include a random time of day.
- Copy or download the list and paste it into your spreadsheet, database or document.
Date Formats Explained
| Format | Example | Best for |
|---|---|---|
| ISO 8601 | 2026-03-14 | Databases, programming, sorting as text, international use |
| US | 03/14/2026 | US spreadsheets and forms (month first) |
| European | 14/03/2026 | UK, Europe, India, Australia (day first) |
| Dotted | 14.03.2026 | Germany, Switzerland, Austria, Russia |
| Long | Saturday, March 14, 2026 | Documents and writing, in your browser's language |
| Unix timestamp | 1773446400 | Programming: 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.