COUNTIFS formula looking at date columns in a reference sheet

Jade Boring

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.

Paul Newcome

You will need a helper column in the source sheet to indicate on each row where there is an issue then count (or sum depending on your indicator) how many rows are flagged in this helper column.

Paul Newcome

You will need a helper column in the source sheet to indicate on each row where there is an issue then count (or sum depending on your indicator) how many rows are flagged in this helper column.

Jade Boring

@Paul Newcome I was thinking that'd be the case. Thank you so much!

Paul Newcome

Happy to help. 👍️