I am trying to calculate how many IT tickets have been moved to the status of "completed" within the last 7 days. The formula returns a value of 6 but when I use the filters on the report, it returns the correct value of 2. Can someone help me with the formula so it returns the correct value of 2?
The formula I have is:
=COUNTIFS(Status:Status, "Complete", [Due Date - OVERALL]:[Due Date - OVERALL], >=TODAY(-7))