How do I generate random numbers using dates in excel?
I want to generate a sample of random dates using Excel 2000.
|
=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. |
All times are GMT +1. The time now is 08:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com