How Many Items "Closed" Recently

Bill Mac

I'm trying to count how many items have been closed in the last 14 days - so "Status" would be "Closed" and the "Date Updated" would be in the last 14 days.

I thought the proper formula would be as I have shown below, but it returns the wrong value.

Any idea where my mistake is?

=COUNTIFS(Status:Status, "Closed", [Date Updated]:[Date Updated], >(TODAY() - 14))

Bill Mac

Sorry, I solved my own issue. To count the last 14 days >(TODAY() - 14) needed to be changed to >=(TODAY() - 14). Without the ">=" I was only counting the last 13 days

Andrée Starå

@Bill Mac

Excellent!

Glad you got it working!

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Bill Mac

Sorry, I solved my own issue. To count the last 14 days >(TODAY() - 14) needed to be changed to >=(TODAY() - 14). Without the ">=" I was only counting the last 13 days

Andrée Starå

@Bill Mac

Excellent!

Glad you got it working!

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!