Help with setting up a shift schedule/roster!

Hi TA who lives in the WWW and has your goals in place, welcome to the forum.

I'm an advocate of pivot tables for these kinds of problems. In Pivot Tables you need to have your data in a TABLE. Then you do a simple pivot and results will appear. To show what I mean, I've attached an example with 5 names. Then I did a random date and calculated Week Number and Year so I could Pivot the data. See attached to see if it meets you needs.