try
= 38352+randbetween(1,5)+7*rand between(0,30)

"STEVEB" wrote:


Hi,

Does anyone have any suggestions for a Random Number Generator 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
F4= 38,564

Any help would be greatly appreciated!

Thanks


--
STEVEB
------------------------------------------------------------------------
STEVEB's Profile: http://www.excelforum.com/member.php...fo&userid=1872
View this thread: http://www.excelforum.com/showthread...hreadid=389443