Calculating number of work days

Jaspal

New Member
Joined
Jun 4, 2010
Messages
40
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
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,545
Are you saying that the 365 day period starts on the first day of his first 28 day on rota?
 

T. Valko

Well-known Member
Joined
May 9, 2009
Messages
16,623
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

Well-known Member
Joined
Jul 8, 2002
Messages
11,545
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

New Member
Joined
Jun 4, 2010
Messages
40

ADVERTISEMENT

... 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
 

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,545

ADVERTISEMENT

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

New Member
Joined
Jun 4, 2010
Messages
40
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

Well-known Member
Joined
Jul 8, 2002
Messages
11,545
Look at this week calendar with the 7 blocks of 28 days marked:

Excel Workbook
ABCDEFGHIJK
1Week numberWorking?days?Week numberWorking?days?Week numberWorking?days?
21Yes721No041Yes7
32Yes722No042Yes7
43Yes723No043Yes7
54Yes724No044Yes7
65No025Yes745No0
76No026Yes746No0
87No027Yes747No0
98No028Yes748No0
109Yes729No049Yes7
1110Yes730No050Yes7
1211Yes731No051Yes7
1312Yes732No052Yes7
1413No033Yes7
1514No034Yes7
1615No035Yes7
1716No036Yes7
1817Yes737No0
1918Yes738No0
2019Yes739No0
2120Yes740No0
Sheet14
 

Jaspal

New Member
Joined
Jun 4, 2010
Messages
40
Look at this week calendar with the 7 blocks of 28 days marked:

Excel Workbook
ABCDEFGHIJK
1Week numberWorking?days?Week numberWorking?days?Week numberWorking?days?
21Yes721No041Yes7
32Yes722No042Yes7
43Yes723No043Yes7
54Yes724No044Yes7
65No025Yes745No0
76No026Yes746No0
87No027Yes747No0
98No028Yes748No0
109Yes729No049Yes7
1110Yes730No050Yes7
1211Yes731No051Yes7
1312Yes732No052Yes7
1413No033Yes7
1514No034Yes7
1615No035Yes7
1716No036Yes7
1817Yes737No0
1918Yes738No0
2019Yes739No0
2120Yes740No0
Sheet14



Many thanks.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,487
Messages
5,601,961
Members
414,486
Latest member
Darkai

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top