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 |
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 |
All times are GMT +1. The time now is 09:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com