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

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. RE: How to generate a random list of weekDAYS between two dates?

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.

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1