Obviously, you are not the first to have to deal with a shift schedule - so
There are all kinds of scheduling applications around (some may even be
free). You might try to google to find some. I doubt a formula would be
useful in this situation and setting up a spread sheet to do it would
probably take a lot of work and not be very robust to boot.

--
Regards,
Tom Ogilvy

<JessiRight77@yahoo.com> wrote in message
news:1112649611.503738.311010@f14g2000cwb.googlegroups.com...
> An addendum...
>
> Well, I was confused... staff will NOT always work 5 days on, then 2
> days off. There could be ANY combination of work days, as long as the
>
> employee does not work more than 40 hours per week, and has off *a*
> Saturday and *a* Sunday at least every 3 weeks.
>
> Could Excel be used to automatically create a work schedule for a group
>
> of employees?
>
> Thanks,
> Jessi
>