CHANGES - Recurring Monthly Numerical Sequence

[kdunn44107]

--------------------------------------------------------------------------------

Various employees have different work schedules, meaning some work si
days are off for two, then work four days, off for two, work four days
off for two, work six days, off for two, and so on. Others hav
different schedules, but all have a reoccuring sequence for the year
The question is, if we enter the sequence for the first month, can w
get it to automatically tabulate the sequence similiarly to days of th
week for the following months. In essence, we would like to enter th
various sequence for each employee into January, and have it continu
the sequence through the rest of the year so that an employee can se
their work days and days off through December.

****I failed to mention, each month is set up on a different tabbe
folder at the bottom of the screen. The dates for each month run acros
the top row and the employees names run down the first column.
received excellent tips, but I don't believe they will work under thes
circumstances. I apologize for the addendum - is there any way to mak
this work over 12 tabbed months?***

 

[Bernie Deitrick]

k,

This will require that you have a shedule sheet. In each column, you will
need to enter an eployee's schedule going down the column. For example,
let's say that your schedule starting the first of the year is
W,W,O,O,O,W,W,W,W,W,O,O and that it repeats from there. Starting in B1,
enter W, then in B2, enter W, B3, O, etc.

Then on your monthly scheduling sheets, with the dates starting in cell B1,
and going across the sheet

=INDEX('Schedule Sheet'!$B:$B,MOD(B1-DATEVALUE("1/1/04"),COUNTA('Schedule
Sheet'!$B:$B))+1)

That will give you your schedule for those days, continuing from month to
month.

You will need to set up a column for each employee.

HTH,
Bernie
MS Excel MVP