Calculating number of work days

[Jaspal]

Hello there,

I am trying to find number of woking days for a Worker in a 365 day period, if he works on a 28 day on and 28 day off rota throughout the year.

Thanks in advance,
Jas

 

[GlennUK]

Are you saying that the 365 day period starts on the first day of his first 28 day on rota?

 

[T. Valko]

Hello there,

I am trying to find number of woking days for a Worker in a 365 day period, if he works on a 28 day on and 28 day off rota throughout the year.

Thanks in advance,
Jas

If the first day of the year is the first day of the start of the shift. Within the 365 day period that person will have worked 196 days.

No formula, just did a manual count.

 

[GlennUK]

If the first day of the year is the first day of the start of the shift. Within the 365 day period that person will have worked 196 days.

No formula, just did a manual count.

... it's the same as the formula =7*28 ... if the 365 day period starts on the first day of his first 28 day on rota.

 

[Jaspal]

... it's the same as the formula =7*28 ... if the 365 day period starts on the first day of his first 28 day on rota.

What is the logic of 7 months (7*28)...Glenn in some cases the workers will work throughout the year, so from 1st Jan - 31st Dec but in some situations they might only work couple of months.

Cheers

 

[Jaspal]

If the first day of the year is the first day of the start of the shift. Within the 365 day period that person will have worked 196 days.

No formula, just did a manual count.

Manual Count?

 

[GlennUK]

What is the logic of 7 months (7*28)...Glenn in some cases the workers will work throughout the year, so from 1st Jan - 31st Dec but in some situations they might only work couple of months.

Cheers

The logic is for working 28 days on and then 28 days off, repeating throughout a 365 day period, starting at the beginning of a 365 day period.

 

[Jaspal]

The logic is for working 28 days on and then 28 days off, repeating throughout a 365 day period, starting at the beginning of a 365 day period.

Thanks Glenn, but I still don't follow. What is the formula or what is the complete thought process?

Cheers

 

[GlennUK]

Look at this week calendar with the 7 blocks of 28 days marked:

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K
1	Week number	Working?	days?		Week number	Working?	days?		Week number	Working?	days?
2	1	Yes	7		21	No	0		41	Yes	7
3	2	Yes	7		22	No	0		42	Yes	7
4	3	Yes	7		23	No	0		43	Yes	7
5	4	Yes	7		24	No	0		44	Yes	7
6	5	No	0		25	Yes	7		45	No	0
7	6	No	0		26	Yes	7		46	No	0
8	7	No	0		27	Yes	7		47	No	0
9	8	No	0		28	Yes	7		48	No	0
10	9	Yes	7		29	No	0		49	Yes	7
11	10	Yes	7		30	No	0		50	Yes	7
12	11	Yes	7		31	No	0		51	Yes	7
13	12	Yes	7		32	No	0		52	Yes	7
14	13	No	0		33	Yes	7
15	14	No	0		34	Yes	7
16	15	No	0		35	Yes	7
17	16	No	0		36	Yes	7
18	17	Yes	7		37	No	0
19	18	Yes	7		38	No	0
20	19	Yes	7		39	No	0
21	20	Yes	7		40	No	0
Sheet14

 

[Jaspal]

Look at this week calendar with the 7 blocks of 28 days marked:

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K
1	Week number	Working?	days?		Week number	Working?	days?		Week number	Working?	days?
2	1	Yes	7		21	No	0		41	Yes	7
3	2	Yes	7		22	No	0		42	Yes	7
4	3	Yes	7		23	No	0		43	Yes	7
5	4	Yes	7		24	No	0		44	Yes	7
6	5	No	0		25	Yes	7		45	No	0
7	6	No	0		26	Yes	7		46	No	0
8	7	No	0		27	Yes	7		47	No	0
9	8	No	0		28	Yes	7		48	No	0
10	9	Yes	7		29	No	0		49	Yes	7
11	10	Yes	7		30	No	0		50	Yes	7
12	11	Yes	7		31	No	0		51	Yes	7
13	12	Yes	7		32	No	0		52	Yes	7
14	13	No	0		33	Yes	7
15	14	No	0		34	Yes	7
16	15	No	0		35	Yes	7
17	16	No	0		36	Yes	7
18	17	Yes	7		37	No	0
19	18	Yes	7		38	No	0
20	19	Yes	7		39	No	0
21	20	Yes	7		40	No	0
Sheet14

Many thanks.