I'm trying to build a sheet for tracking compliance with training. I'm needing to build some summary fields, which show how many procedures a person is current on, how many they are out of date with, and how many have had a new procedure issued since they were trained.

So for the data shown below, I need:

- one calculation that looks at the three dates next to person A, and figures out how many of them are later than both Date 1 and Date 2 above them
- one calculation that looks at the three dates next to person A, and figures out how many of them are in between Date 1 and Date 2 above them
- one calculation that looks at the three dates next to person A, and figures out how many of them are earlier than both Date 1 and Date 2 above them

I've been trying an array formula using the below, but it doesn't seem to work as I hoped. It only works if the date next to person A is bigger than every single date next to Date 1 and Date 2, not just in the column above it.

```
=COUNTIFS($G65:$GX65,">="&$G$10:$GX$10,$G65:$GX65,">="&$G$6:$GX$6)
```

I've also tried adding a character to the date next to person A using conditional formatting, but the COUNTIF function doesn't find that character if added by formatting.

Any tips?