Generate Random Date In Excel

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



Drag the formula to the rows below to generate sequence of dates.

Hope this helped.

Share The Knowledge

Random Posts

Leave a Reply