Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to generate a random list of weekDAYS between two dates?
I need to generate a random list of day, excluding saturday and sunday,
between two dates. This is for assigning items to be counted as part of a cycle count. I can generate the random list which more or less distributes the items between the two days but it includes saturdays and sundays. I need the assignment without weekends. |
#2
|
|||
|
|||
First create a table of available dates. Enter the first date (say in A1)
and grab the lowerleft hand corner and drag it down as far as needed ( tell the option to fill series). Next in B1 enter =RAND()+(WEEKDAY(A1)=7)*10+(WEEKDAY(A1)=1)*10 and copy down. Notice that the B cells are "large" for weekend days. Just sort by column B. Notice that the weekend days sink to the bottom. Take as many days of the top of the list as you want to sample. -- Gary''s Student "Yanzel Muniz" wrote: I need to generate a random list of day, excluding saturday and sunday, between two dates. This is for assigning items to be counted as part of a cycle count. I can generate the random list which more or less distributes the items between the two days but it includes saturdays and sundays. I need the assignment without weekends. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Random items from a list? | Excel Discussion (Misc queries) | |||
GENERATE RANDOM NUMBERS BUT EXCLUDE A NUMBER IN THE SEQUENCE | Excel Discussion (Misc queries) | |||
Setting up a random list from long list of names ? | Excel Discussion (Misc queries) | |||
Random list (1-45) without repeating numbers? | Excel Worksheet Functions | |||
generate random numbers | Excel Worksheet Functions |