Rotating Roster

[cplspafford]

I am making a work roster for employees. What I am trying to do is as follows:

What I need is to have all employees on a roster and have them show up on their work days only. We work a rotating schedule of 4 days on and 2 days off.

So I need to open the workbook on monday for instance, and know who is working on that day. I am getting caught up because of the rotating (4 on and 2 off) schedule.

If anyone knows of a formula or a way I could accomplish this I would be very greatfull. I have a basic/intermediate knowledge of excel so if it could be explained in idiot format, it would be apprecitated. Thank you in advanced.

[Stuart Farr]

Take a look at the attached file which deals with the 4 on 2 off scenario albeit a little clumsy. This may give you an idea to develop further.