G Gary''s Student Aug 8, 2008 #2 =RANDBETWEEN(DATEVALUE("1/18/1945"),DATEVALUE("1/25/2005")) adjust the dates to suit.
D David Biddulph Aug 8, 2008 #3 =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)
=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)