Generate Names in a Calendar

Hey Everyone,

I'm trying to put together a calendar spreadsheet with the following scenario:

- There are 3 seats in an office.
- 8 people in the pool to fill those seats.
- 7 of the people should work in the office twice a week and 1 of the people will only work their once a week.

Does anyone know of the best way to fill out this calendar using formulas so that everyone gets an even split of the days they work in the office?

Let me know if you need more information.

Thanks in advance,
Freybe