I have the basics of a rotating 6 man roster, which rotates weekly by line. That is the staff member on line one becomes staff member on line two. This occurs from line 1 to line 4 line 5 and 6 rotate between themselves on a weekly basis.
In my basic knowledge of excel formulas I have had no luck. What I would like to happen is;
Staff member on line 1 rotates to line 2 after a week, staff member 2 rotates to line 3 after a week etc etc. Has anyone any suggestions please. Excel 2010
Mike
Bookmarks