absence tracker

  1. M

    Calculate absences within a period

    Hello I'm hoping you can help if possible please. I have a spreadsheet with 3 tabs, on tab 1 is the formulas / calculations, tab 2 holds all the data and tab 3 has dates (start/end date). I am trying to calculate how many occasions of absence an employee has within a 6 month period and...
  2. D

    Seeking Formula help to count consecutive weekday absences

    ABCDEFGHIJK1Employee IDWorkerTypeTime Off DateApproved Hoursneed to count consecutive WEEKDAYS absent at each change in Employee ID - using the absence dates in Column H and using the Saturday/Sunday weekendsExpected ResponseNote - actual worksheet will have over 50,000...

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