Rolling sickness tracking at work

Hello everyone,

My level of Excel knowledge is fairly basic. I need to design the most simplistic way to monitor sickness for a small business on a rolling basis. (Total absences in a rolling year, number of periods of absences in a rolling 3 month period, number of separate days in a rolling 3 month period)

Would someone be able to suggest the easiest way to display and track the information as described above?

I appreciate any help as I'm a little stuck with this.

dnlshllrd

Hi, and welcome to the forum.

It all depends on your data layout. Upload your workbook with some sample data and manually add the results you expect to see and no doubt we can help with a solution.

Incidentally, would you add your location to your profile. It often helps to know this, particularly when dates are concerned or we need to consider particular regional settings like list separators for example.

Hi,

See if the attached (sheet 2) helps.

You should record your absences in a simple table (columns A & B)
Change E2 & E3 as necessary. The rolling sickness count is shown in the table starting in E5.

In the real world you'll probably want to keep the data on one sheet and have the results on a second sheet, but no doubt you get the idea.

Hi,

Yes just put

Formula:

Please Login or Register  to view this content.

in F3 and

Formula:

Please Login or Register  to view this content.

in E2

This is working for us. The only thing it doesn't account for is counting for periods of absence in addition to just single days. Is there an easy way to incorporate this into the design?

EDIT: Another problem I've just encountered is accounting for pro-rated days. Some employees days will need to account for more than '1' to account for the hours they work.