How to generate a random list of weekDAYS between two dates?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I change weekends from Sat, Sun to Fri, Sat in networkdays 3
Determining the Sunday date of the third "full" weekend of a month 25
Networkdays including Saturday? 5
Networkdays plus Sundays 8
How do I calculate future date after number of days 1
How to calculate the number of Workdays for irregular work pattern 1
Re: How can I count the number of SATURDAYS in a month? 0
Calculate workdays for irregular work patterns 1

Back
Top