sickness tracker

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

    Sumproduct across multiple sheets or rows

    Hi all, First time posting. Having a nightmare with "Sumproduct" I've created a spreadsheet for my company that monitors annual leave and sickness. I have a total number of sickness days, as well as a sumproduct formula to work out occasions of sickness-...

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