sickness trigger spreadsheet

[charlottech]

Hello

I am looking at how it is possible to create an excel spread sheet to monitor employee sickness triggers

The triggers are

Three spells of absence over a rolling six month period amounting in total over the period to five working days or more.

A total of 15 intermittent working days or more absence in any 12 month rolling period - intermittent should refer to three or more occasions.

Has anyone got any examples? Currently we have no system in place

thank you

[AliGW]

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.