Countif date is more than 5 days ago but less than 7 days

jedelman

Struggling with this and I'm not sure why.

I want to gather a count of Opened Events that were initiated more than 5 days ago but less than 7 days ago. So I want a count on all Events that have a Date initiated that is 5 or 6 days ago but nothing beyond 7.

Thank you in advance

ker9

@jedelman

If you want all the dates that are < or = to 6 days ago:

=COUNTIF([Opened Events]:[Opened Events], >=TODAY(-6))

If you want dates that are only 5-6 days ago:

=COUNTIFS([Opened Events]:[Opened Events], >=TODAY(-6), [Opened Events]:[Opened Events], <=TODAY(-5))

Hope this helps!

ker9

@jedelman

If you want all the dates that are < or = to 6 days ago:

=COUNTIF([Opened Events]:[Opened Events], >=TODAY(-6))

If you want dates that are only 5-6 days ago:

=COUNTIFS([Opened Events]:[Opened Events], >=TODAY(-6), [Opened Events]:[Opened Events], <=TODAY(-5))

Hope this helps!

jedelman

@ker9

Thank you very much, not sure why I couldn't quite get that one together. Very much appreciate it!