Forum Discussion
Excel: Adding staff absences on a rolling 365 days. Plus recording Bradford Factor scores
So I have to work out my staff's sickness days and calculate their Bradford Factor score. However, this is done on a rolling 365 days from the day I work this out. I've tried using "A" for absenc...
Hey yes that's correct. I'm quite new to using the date formula and functions.
As we're working with actual staff absences we're not working on a basis of an average unfortunately but more exact days. HR requests this too.
As we're working with actual staff absences we're not working on a basis of an average unfortunately but more exact days. HR requests this too.
sorry I'm lost. Which of my comments/questions is correct? If you aren't doing average then what are you doing/trying to get?