Let’s see how to generate a list of random date between two dates in excel.
We will write a simple formula in excel using RANDBETWEEN and NETWORKDAYS function in excel to generate random weekdays dates.
Date 1 is the starting date and Date 2 is the ending date and we would like to generate dates between these two.
Enter the formula below
=WORKDAY($B$1-1,RANDBETWEEN(1,NETWORKDAYS($B$1,$B$2)))
Drag the formula to the rows below to generate sequence of dates.
Hope this helped.
