Random Shifts allocation

Good afternoon everyone,

I am trying to have my Excel spreadsheet to generate random shifts pattern based on the following:

Column A (A2 to A17): Names of team members
Cell B1 to F1: Day of the week (Monday to Friday)

I have 2 shifts available in cell A19 (Early Shift) and A20 (Late Shift).

There are also 2 restrictions is:

- If a member does a late shift on a day, he cannot do an early shift the next day.
- Only 1 person on Early and 1 person on Late per day.

I have attached the spreadsheet.

Could anyone help on this please?

Thank you very much