Hello
I would love some help with my spreadsheet.
I am hoping to use it to track absence, holidays etc.
It's the sickness absence I am really stuck with, at the present time it adds up the total amount of days absent but we work on the following trigger points;
3 instances of sickness in a rolling 6 month period, or
8 or more days sickness in a rolling 12 month period
Can anyone help to add these?
Also most of the staff work Monday to Friday, so I could exclude weekends, but then we have some shift workers who work Sundays. I don't know how to get the sheet to ignore weekends for some people and not for others. It's especially important for the sickness calculation so they aren't counted as extra periods of absence due to it being over a weekend.
If it is possible is there a way of having a new worksheet each year that carries forward the data from the year before (rolling 12 months) for the sickness triggers.
Sorry I am not great with complicated formulas so thanks in advance for any help.
Can anyone help?
I would love some help with my spreadsheet.
I am hoping to use it to track absence, holidays etc.
It's the sickness absence I am really stuck with, at the present time it adds up the total amount of days absent but we work on the following trigger points;
3 instances of sickness in a rolling 6 month period, or
8 or more days sickness in a rolling 12 month period
Can anyone help to add these?
Also most of the staff work Monday to Friday, so I could exclude weekends, but then we have some shift workers who work Sundays. I don't know how to get the sheet to ignore weekends for some people and not for others. It's especially important for the sickness calculation so they aren't counted as extra periods of absence due to it being over a weekend.
If it is possible is there a way of having a new worksheet each year that carries forward the data from the year before (rolling 12 months) for the sickness triggers.
Sorry I am not great with complicated formulas so thanks in advance for any help.
Can anyone help?
