Absence Tracker with rolling 6 months Bradford Factor

Try the following in cell NE4: =SUMPRODUCT(COUNTIFS(B4:ND4,NL$5:NL$10,B$2:ND$2,">="&EDATE(NM$1,-6),B$2:ND$2,"<="&NM$1))
Note that the formula may be copied down column NE without modification.
Note that the formula references cell NM1 which, for test purposes, may contain 12/31/2020 so that cell NE4 will display 3 just as it does now.
After testing you may place =TODAY() in cell NM1.
Let us know if you have any questions.