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

G

Gary''s Student

=RANDBETWEEN(DATEVALUE("1/18/1945"),DATEVALUE("1/25/2005"))

adjust the dates to suit.
 
D

David Biddulph

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