Hi

We have a system in New Zealand where we need to randomly select one day a
week over one year, simple in itself. However we are to incude all the days
of the week over a 5 week period e.g if we choose Tuesday this week the other
four days need to be randomly selected the following week, three days need
the following week etc restarting five days again at week six.

I need a formular or method of excluding previously selected numbers but
giving all remaining numbers an equal chance of selection.

This needs to be set out on a spread sheet for the entire year

Would really appreciate some advice

Thanks

Regards Brad