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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I want to generate random times (every couple of hours) for dates 1
Random List Generation 4
How to generate a random list of weekDAYS between two dates? 1
How do I generate random numbers using dates in excel? 1
Excel Average dates help 0
how do I sort a column of random dates into Consecutive dates 2
Count number of dates between a specified period of time 2
Excel Display certain dates 9

Top