Generate Random Dates in Excel and Google Sheets

Set up the start and end dates

Use the date controls or a DATE formula to create the two inputs. Text such as 04/05/2026 can mean different dates in different locales. For an unambiguous example, enter the formulas below rather than relying on how a typed slash date is interpreted.

Check that the start is not after the end. The dollar signs keep the input references fixed when you fill D2 down. Each result cell makes a new draw; repeats are allowed, and the output is not automatically sorted.

Generate one date or fill a column

=RANDBETWEEN($B$2,$B$3)

In Excel, select D2 and choose a Date format from the Home tab’s number-format control. In Google Sheets, use Format → Number → Date. Fill the formula down to create additional results.

A result such as 46129 is usually a date serial displayed as a number. Changing the number format changes its appearance; it does not require drawing a different date. Keep start, end and result cells formatted consistently when checking the range.

For a small, one-off draw, use the random date generator instead of creating a sheet. It supports a date range, weekday/weekend filters, output formats and an optional time, with up to ten results per draw.

Generate random weekdays without rejection

For Monday–Friday dates, count the working days first, draw a position from 1 through that count, then move forward by that many workdays. The weekend code 1 means Saturday and Sunday. The formula works with the B2 and B3 date inputs above.

=IF(NETWORKDAYS.INTL($B$2,$B$3,1)=0,"No weekdays",WORKDAY.INTL($B$2-1,RANDBETWEEN(1,NETWORKDAYS.INTL($B$2,$B$3,1)),1))

The starting point is B2 minus one day so that an eligible B2 can be the first result. A weekend-only range returns “No weekdays” instead of asking RANDBETWEEN to draw from an empty pool. Keep B2 no later than B3.

Weekdays and business days are different requirements. If holidays must be excluded, maintain a holiday-date range and pass that same range as the holidays argument to both NETWORKDAYS.INTL and WORKDAY.INTL. The browser tool’s weekday switch does not provide a holiday calendar.

Add a random time at whole-minute resolution

If D2 already contains the chosen date, put this in E2 to add any minute from 00:00 through 23:59:

=D2+RANDBETWEEN(0,1439)/1440

Format E2 as a date and time. A day contains 1,440 minutes, so the added fraction stays within D2’s calendar day. A value of zero represents midnight. This example does not generate seconds or enforce appointment-length spacing.

For a restricted time window in the browser tool, enable the time option and set the earliest and latest times. Decide whether you need a calendar date, a local clock time, or a timezone-aware timestamp; those are different data requirements.

Keep the chosen dates from changing

Random formulas can produce new results when the sheet recalculates. Once you want to keep a draw, copy the output into a separate destination and paste values only. In Excel, choose a Values paste option; in Sheets, use Edit → Paste special → Values only. Apply the date or date-time format to the destination if needed.

1. Confirm every result is between the start and end dates.
2. For a weekday-only draw, confirm no result falls on Saturday or Sunday.
3. Keep a values-only copy and compare it with the result you intended to save.

Repeated dates are valid for these formulas. If you require different dates, create the eligible day list, shuffle it and take a subset. Do not remove duplicates from a requested sample and assume you still have the requested number of dates.

Common problems and the right next step

For keeping names, IDs and dates together when you shuffle records, follow the whole-row randomization guide. For a new list of distinct numeric IDs, use the unique random-number formulas.