How do I generate random numbers using dates in excel?

N

N Harkawat

=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
 

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

How can I generate a list of random dates from dates I specify 2
eliminate negative value from normal random number distribution 4
Generating random numbers 2
random number generator 6
RANDBETWEEN generating numbers outside range 5
RANDBETWEEN() 9
I want to generate random times (every couple of hours) for dates 1
How do I generate random lottery numbers in Excel? 7

Top