Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Random Number Generator
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Random Number Generator
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
random number generator | Excel Worksheet Functions | |||
Random number generator | Excel Worksheet Functions | |||
random number generator | Excel Discussion (Misc queries) | |||
random number generator | Excel Programming | |||
Random Number Generator | Excel Programming |