Absence Tracker with rolling 6 months Bradford Factor

Hello,

I'm new to excel and i'm trying to make a sickness & holiday tracker with a rolling 6 month bradford factor trigger system built into to it.

I think I've figured out how to log single sick days and consecutive sick days but i'd like them to flag up based on the last six months per colleague.

The trigger points criteria would be 5 days of single sick days or more or 3 occasions of more than 1 day in a 6 month rolling period and I guess a simple red flag trigger if that condition is met?

I've a few key code that i'd like to be included for example S = sickness, M = Migraine etc... just for reference but I want it all to be included in my total (just red keys from column NL)

I'm sure there will be more questions but any help will be gratefully received.