# work day

1. ### Calculate number of sickness days with rolling shift patterns

I am looking to find out if there is a way to use excel formula to work out the cumulative number of working days a employee has been absent for when they work shift patterns So if the shift patterns are 4 on 4off, 2 days week one and 5 days week day two and the last shift pattern we have is 2...
2. ### Creating pivot table or report that displays dates worked and in which section.

Hi, I worked at a nonprofit that needs to track volunteer activity by date worked and section worked in. I cannot figure out a way to make a pivot table that would collect individual volunteer activity by date and then display the 10 dates worked and also a pivot table that would collect...
3. ### Need help returning second business day of the month please!

Hey guys really frustrated. I am having trouble finding a formula to calculate the second business day of the month. I need this for the rest of my code. The closest thing I found is: Private Sub Workbook_Open() Dim lngEoM As Long lngEoM = Date-Day(Date) If Date = lngEOM +...
4. ### Calculate future working date and time

My worksheet includes the ff: E11: 0.0416666666666667 (in days) --> basically, this is 1 hour F11: Start Date/Time (3/24/10 4:50PM) G11: End Date/Time What I would like to happen is to add E11 to F11 taking into account that it should only add working days and working hours (8:00AM to 5:00PM)...

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