Creating a Schedule That’s Filled From a List of Names

Zac6Smith You're in luck.  I created something I think may work for you.  in the attached i have 2 tabs. The first is the 'registration' tab where you enter names, unique ID#s (must be a number) and then for each date if they are available.  There is also a "Level" column that you can ignore or enter the same value for all (this was set up for something like a tennis league so that the 'top' players stay grouped near the top and bottom near bottom but allows some level of mixing).  

The second sheet has a RNG level that doesn't matter in this case (again works with that 'Level' column) and the a Date input (drop down in B6).  When you select a date it will give you a pseudoRandomized list unique for that date.  You can then use the top X number as the employees to work.  It is (IMHO) much better than just using RAND functions because it is repeatable.  The "seed" is based on a combination of ID# and Date so as long as the ID doesn't change their pRNG for that date won't change either.