absence periods

  1. H

    Monitoring sick pay over a rolling 12 month period - with two levels of pay

    Hi All I've been staring at this for two days and I'm stuck, hope you can help me. The company I work for looks at sickness for a rolling 12 month period. In that period, we pay 100% pay for the first 65 days of absence, 50% pay for the subsequent 65 days of absence, and then 0 after that...
    • HRJon
    • Thread
    • absence periods pay calculation sick days sickness tracker
    • Replies: 4
    • Forum: Excel Questions
  2. S

    Consecutive dates excel

    Hi, Having some problems trying to work out a formula to count incidents of absence. I have a report which gives me a list a column of names and next to it dates they have been absent. I want to work out the incidences of absence, e.g Johan - 01/01/2017, 02/01/2017, 03/01/2017, 10/02/2017 in...
    • sjurawan
    • Thread
    • absence absence periods absences date employee count
    • Replies: 2
    • Forum: Excel Questions
  3. D

    Absence Periods Calculation - Excel 2010

    Can you help, I have an absence sheet which shows each employee number and each period of absence - start and end date, in the following columns <TBODY> Emp ID Forename Surname Start Date End Date 121 John Dodge 16/05/14 16/05/14 121 John Dodge 19/05/14 19/05/14 154 Stacey Dash 12/02/14...

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