Callendar 4 days on shift and 4 days off shift

[ForFun]

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.

 

[ForFun]

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

 

[ForFun]

Bump

 

[ForFun]

Can anyone suggest or help me with this?

 

[ForFun]

0 replies !!

 

[CsJHUN]

hi!

try this:
In C6 (or your first cell) write the starting date, then:
(please adjust the formulas to your need)

<tbody></tbody>

Excel 2010 32 bit
	C	D	E	F	G	H	I	J	K	L	M	N	O	P
6	1-Jan	2-Jan	3-Jan	4-Jan		9-Jan	10-Jan	11-Jan	12-Jan		17-Jan	18-Jan	19-Jan	20-Jan
Sheet1

Cell Formulas
Range	Formula
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

 

[ForFun]

hi!

try this:
In C6 (or your first cell) write the starting date, then:
(please adjust the formulas to your need)

Excel 2010 32 bit

	C	D	E	F	G	H	I	J	K	L	M	N	O	P
6	1-Jan	2-Jan	3-Jan	4-Jan		9-Jan	10-Jan	11-Jan	12-Jan		17-Jan	18-Jan	19-Jan	20-Jan

<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Worksheet Formulas Cell Formula 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 <thead> </thead><tbody> </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 ))