# Callendar 4 days on shift and 4 days off shift

#### ForFun

##### New Member
Hi all,

I have encountered a difficult formula to finish my spread sheet. I would like to generate calendar with 4 days on shift for holidays that will be divided into 4 columns, and 4 days off that will not be displayed, but it will be compressed into one column.

I have 2 tabs. First is Holidays in which I have days on shift for Green shift and I would like that it will collect dates from second tab which is calendar with generated days for whole year.

Many Thanks for all help.

### Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

#### ForFun

##### New Member
Sorry, but I can't edit above post.
I would like to add one more picture of how do I see collection of dates.

Bump

#### ForFun

##### New Member
Can anyone suggest or help me with this?

0 replies !!

#### CsJHUN

##### Active Member
hi!

try this:
In C6 (or your first cell) write the starting date, then:

<tbody></tbody>

Excel 2010 32 bit
CDEFGHIJKLMNOP
61-Jan2-Jan3-Jan4-Jan9-Jan10-Jan11-Jan12-Jan17-Jan18-Jan19-Jan20-Jan
Sheet1
Cell Formulas
RangeFormula
D6=C6+1
E6=D6+1
F6=E6+1
H6=C6+8
I6=H6+1
J6=I6+1
K6=J6+1
M6=H6+8
N6=M6+1
O6=N6+1
P6=O6+1

Please also notice the 1st-2nd & 3rd formula are different than 5-6-7-8 formula (4th is empty), you need to copy this segment with an extra empty cell (H6:L6) to left

Last edited:

#### ForFun

##### New Member
hi!

try this:
In C6 (or your first cell) write the starting date, then:

Excel 2010 32 bit
CDEFGHIJKLMNOP
61-Jan2-Jan3-Jan4-Jan9-Jan10-Jan11-Jan12-Jan17-Jan18-Jan19-Jan20-Jan

</tbody>

Worksheet Formulas
CellFormula
D6=C6+1
E6=D6+1
F6=E6+1
H6=C6+8
I6=H6+1
J6=I6+1
K6=J6+1
M6=H6+8
N6=M6+1
O6=N6+1
P6=O6+1

</tbody>

<tbody>
</tbody>

Please also notice the 1st-2nd & 3rd formula are different than 5-6-7-8 formula (4th is empty), you need to copy this segment with an extra empty cell (H6:L6) to left

Awesome!!!
Thank you a lot for this function ))

Replies
1
Views
83
Replies
1
Views
63
Replies
0
Views
776
Replies
11
Views
321
Replies
1
Views
149

1,190,898
Messages
5,983,456
Members
439,843
Latest member
PlanetFitness

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back