| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I generate random numbers using dates in excel?
I want to generate a sample of random dates using Excel 2000.
|
|
#2
|
|||
|
|||
|
=DATE(2005,1,1)+IF(RAND()0.5,RAND()*-1000,RAND()*1000)
will generate random dates 1000 days plus and 1000 days minus 1/1/2005 Ofcourse format it as date "celia w" <celia wrote in message ... I want to generate a sample of random dates using Excel 2000. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Generate random numbers 1-100 without any repeats? | Excel Worksheet Functions | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| Generate random numbers between two values and with a given mean | Excel Worksheet Functions | |||
| Validating random numbers | Excel Worksheet Functions | |||
| generate random numbers | Excel Worksheet Functions | |||
Linear Mode
