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.
Bookmarks