Generate Random Date In Excel

Let’s see how to generate a list of random date between two dates in excel.

Capture

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)))

Capture

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

Hope this helped.

Share The Knowledge

Random Posts

  • Select N Rows In Excel Formula

    In this post we will see how we could select n rows in any excel formula. Suppose we have data […]

    Share The Knowledge
  • Change Name Range In Excel

    Name range is of the most useful features in excel.The challenge in our day to day excel activities are that […]

    Share The Knowledge
  • Colour Sheet Name In Excel

    We can colour the name tab of the sheet as per our requirement as shown below in the screenshot. Let’s […]

    Share The Knowledge
  • Excel VBA To Delete Shape Whose Name Starts With Certain String

    Delete shapes in excel if the name has certain string, delete shape in excel based on the names, excel delete shapes on the basis string in the name, excel delete shape looping through shape names

    Share The Knowledge

Leave a Reply