Recurring Monthly Numerical Sequence

  • Thread starter Thread starter kdunn44107
  • Start date Start date
K

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
 
Let's say you have the sheet set up with the employee names as column headers
(in row 1) and dates as row headers (in column A), and below the employee's
name you have something like WORK or OFF. What you have described is a 14 day
cycle. So in B2:B15 you would enter the data for the 1st 14 days, as below. (I
used W instead of WORK, O instead of OFF, but you get the point, I'm sure.)


W
W
W
W
W
W
O
O
W
W
W
W
O
O

In B16, put the formula =B2 and copy it down through the end of the year.
 
Various employees have different work schedules, meaning some work six
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 have
different schedules, but all have a reoccuring sequence for the year.
The question is, if we enter the sequence for the first month, can we
get it to automatically tabulate the sequence similiarly to days of the
week for the following months. In essence, we would like to enter the
various sequence for each employee into January, and have it continue
the sequence through the rest of the year so that an employee can see
their work days and days off through December.
Click to expand...

You can't do it by entering for a month, since months do not have an equal
number of days.

But you could do it by entering one full sequence, and then using formulas.

For example, if an employees sequence was W6,O2,W4,O2,W4,O2,W6,O2 and that
repeated, you have a cycle length of 6+2+4+2+4+2+6+2 = 28 days

So you would start your calendar like this:

(In columns A & B)

1-Jan W
2-Jan W
3-Jan W
4-Jan W
5-Jan W
6-Jan W
7-Jan O
8-Jan O
9-Jan W
10-Jan W
11-Jan W
12-Jan W
13-Jan O
14-Jan O
15-Jan W
16-Jan W
17-Jan W
18-Jan W
19-Jan O
20-Jan O
21-Jan W
22-Jan W
23-Jan W
24-Jan W
25-Jan W
26-Jan W
27-Jan O
28-Jan O

Then in Row 29 you might have:

=A28+1 =B1

and just copy/drag that down as far as necessary.


--ron
 
Back
Top