Random Date Generator
Pick random dates from any window — a week, a year, a century — filtered to the days of the week you care about and formatted the way your spreadsheet expects.
Distinct Dates, Not Just Random Ones
Asking for five random dates and getting the same Tuesday twice is the usual failure of a date picker, and it matters most in exactly the case people use one for: laying out a schedule. Every draw here is a set of distinct dates, drawn uniformly from the pool and returned in order, so the result is something you can paste straight into a calendar.
If fewer dates match than you asked for — ten Mondays inside a fortnight — you get the ones that exist and a note saying how many. The alternative, quietly returning duplicates or a shorter list with no explanation, is how a plan ends up with two audits booked on the same day.
Filtering by Day of the Week
The weekday checkboxes narrow the pool before anything is drawn, which is not the same as drawing dates and throwing away the ones that land wrong. It is what makes "a random Friday in the next three years" a real question with a real answer: the pool is 156 Fridays, each equally likely, and the tool knows that without walking a thousand days to find out.
That is the control worth reaching for whenever a date has to look unplanned but still land inside working hours — surprise inspections, spot checks, rotating on-call slots, or a weekly meeting whose day nobody gets to choose.
Frequently Asked Questions
How does the random date generator work?
Set a start date and an end date, and the generator picks dates uniformly from every day in that window, including both endpoints. Each date in a single draw is distinct, so a request for five dates gives you five different days rather than the same one twice.
Can I exclude weekends from random date selection?
Yes. Untick Saturday and Sunday under 'Days to include' and only weekdays stay in the pool. The same control works the other way round — tick only Friday to draw random Fridays, which is how you sample a weekly slot.
What date ranges can I use?
Any range you can enter in the two date fields, from a few days to several centuries. The generator addresses the pool by index rather than searching it, so a ten-year Fridays-only draw is as fast as a one-week draw.
What if fewer dates match than I asked for?
You get every date that matches and a note saying how many that was. Asking for ten Mondays inside a two-week window returns two Mondays, not two Mondays and eight repeats.
What are common uses for a random date generator?
Scheduling audits or inspections at unpredictable dates inside a compliance window, drawing sample dates for research, generating realistic test data, picking contest or drawing dates, and randomising a rota so no one can game the order.