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

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

--
steveB

Remove "AYN" from email to respond
"STEVEB" wrote in
message ...

Hi,

Does anyone have any suggestions for a Macro that would run a Random
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!

Thanks


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