How to generate random dates

In this worksheet, let’s generate 20 random dates between May 1 and May 30, 2020.

In cell C6, I’ll enter 20 since we want 20 dates total.

In cell E5, I’ll enter the RANDARRAY function.

Forcolumns, we want 1.

Formin, we want the start date in C4.

Formax,we want the end date in C5.

When I enter the formula, RANDARRAY generates 20 random dates in May.

Remember that these values need to be formatted as dates.

Now when I change the start or end date, we’ll get a new set of dates.

I can also change the number of dates that are created.

Now, the output from RANDARRAY is not sorted.

If I need the dates to be sorted, I can wrap theSORT functionaround RANDARRAY.

Finally, note that RANDARRAY generates dynamic values, not fixed values.