How can I generate a list of random dates from dates I specify

  • Thread starter Thread starter JJ TUMIA
  • Start date Start date
=RANDBETWEEN(DATEVALUE("1/18/1945"),DATEVALUE("1/25/2005"))

adjust the dates to suit.
 
=rand() in a helper column alongside your list of dates.
Sort the two columns together, sorting by the rand column.

If you merely want a random date between 2 specified dates, try
=RANDBETWEEN(A2,A3)
 
Back
Top