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

--
STEVE
-----------------------------------------------------------------------
STEVEB's Profile: http://www.excelforum.com/member.php...nfo&userid=187
View this thread: http://www.excelforum.com/showthread.php?threadid=38945