Random Number Generator

S

STEVEB

Hi,

Does anyone have any suggestions for a Macro that would run a Rando
Number Generator for 50 rows that would only return weekdays?

This is my current formula (which works great but generates Saturday
Sunday days):


=RAND()*($F$4-$F$3)+$F$3

F3= 38,353 (January 1, 2005)
F4= 38,564 (July 31, 2005)

Any help would be greatly appreciated!

Thank
 
S

STEVE BELL

This seemed to work for me in Excel 2000
as a worksheet function.

=WORKDAY(F1,RANDBETWEEN(F3,F4))
 

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

Random Number Generator 7
Non Uniform Random Number Generator 2
Manpower Calendar Distribution, Skipping weekends. 0
Generating random numbers from a given range 12
Month days over a time period 5
random number generation help 3
random number generator 2
Random generator question 3

Top