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