View Single Post
  #2   Report Post  
Gary''s Student
 
Posts: n/a
Default Random Date Generation

In column A list all the dates between 1/1/05 and 10/31/05
In cell B1 enter:
=RAND() and copy down
Sort both columns by column B. This will randomize the data in column A.

Just copy out the first 15 items in column A

To get a different 15, pump F9 and resort.
--
Gary's Student


"TNMAN" wrote:

Could someone please help me generate a list of 15 random dates between
1/1/05 and 10/31/05 without any duplicates? Thanks in advance for all your
help.

Frustrated in Tennessee