COUNTIFS formula looking at date columns in a reference sheet
I used the Inspection Tracking template set a base. I liked it as a starting point, and added expiration dates. Looking at the metrics sheet provided, it uses this formula to look at the number of violations per month.
I also want to see the number of date violations that occurred per month. Date violations would be anything expired, so anything in the past compared to the Date (which is a Created Date column that goes off of a form attached to the source sheet). Long story short, my formula is giving me an invalid data type error and I can't seem to figure out why.
Date is a reference to the create date column and AED Expiration Date is a reference to a date column in the same sheet.
Help Article Resources
Check out the Formula Handbook template!