=SUMPRODUCT(--(ISBLANK($A$2:$A$10)),--($B$2:$B$10="ACT"),--(C2:C10=X1-183))

where X1 is "Report date"

"MaryZZZ" wrote:

Made a mistake in my previous post. Dawns on me that as time passes,
soon I will not have any rows selected if I compare dates to TODAY().
The data is static and TODAY() is not.

I suppose I need to add a "REPORT Date" to a cell on the spreadsheet,
and count the rows that are GT ("REPORT Date" - 6 months).