Weekly Rotation Schedule

M,

on the date, I'd use a fixed date to generate the schedule. With a dynamic date function (like Now() or Today()), each time the date changes, the schedule would change.

I've rejigged your sheet a bit. It generates a schedule for 52 weeks starting from the Monday in the week of the date entered in B1.

The other thing to be careful with in this sheet are the named ranges. I've named the list of names as Group1, Group2 and SuperAdminGroup.

See if this works.

Cheers