Hello,
I'm trying to count the number of times a type of dispute occurs within a month in the last 6 months in order to monitor trends. I want the months to roll so I don't need to adjust the formulas ever. My formula doesn't take the previous year into account and I'm not sure how to introduce it. This is what my background sheet looks like currently - gets stuck on 5 months ago, or Dec. 2020.
This is my formula right now that's pulling from the source sheet:
=COUNTIFS({B-Stock Dispute Tracker Range 4}, "short - entire order", {B-Stock Dispute Tracker Range 3}, AND(IFERROR(MONTH(@cell), 0) = MONTH(DATE(YEAR(TODAY()), MONTH(TODAY()) - 4), IFERROR(YEAR(@cell), 0) = YEAR(DATE(YEAR(TODAY()), MONTH(TODAY()), 1) - 1))))
B-Stock Dispute Tracker Range 4 is my Dispute Type column. B-Stock Dispute Tracker Range 3 is my Dispute Entry Date column.
Any help would be appreciated!
Rai