I tried the formulas here, but they are all returning #VALUE .
https://www.mrexcel.com/forum/excel-questions/503651-counting-number-times-specific-month-appears-range.html
Please note that I am referencing a separate workbook ('[2018 Claim Status Sheet.xlsx]Active Claims') which has the dates...