Conditional formatting after 4 occurrences over 14 day period

Good morning,

I am tracking the number of COVID-19 cases at my workplace and I need to highlight all of the cases after five cases in a department over the past 14 days. My boss wants a visual cue so that we don't miss something when someone sorts the sheet differently than our standard sort.

I have found a number of conditional formatting formulas to highlight after x number of occurrences, but nothing that includes a rolling 14 days.

My columns are:
- A: date of positive case
- B: employee id
- C: name
- D: department

Any help is greatly appreciated. Thank you in advance.

There are instructions at the top of the page explaining how to attach your sample workbook.

Try:

=COUNTIF($A$2:A2,">="&A2-14)>4