work day

  1. A

    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...
    • Aiburto
    • Thread
    • #excel #formulahelp count & count ifs counting worked days if & countif if & network network days networkdays.intl no end date shifts sum work day
    • Replies: 4
    • Forum: Excel Questions
  2. S

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

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

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