I am using the following COUNTIFS formula to count the number of rows who meet two conditions. The first condition is that the Status column equals "RESOLVED"' the second condition is that the Resolved Date column is >= (greater than or equal to) Cell A1. Cell A1 is autocalcualted to be today's date minus 7. The end result should tell me how many rows were marked Resolved in the last 7 days (in this example the result should be 2). But it always comes out to ZERO.
<tbody>
</tbody>
Thanks in advance for the help!
Chris J.
=NOW()-7 = 3-Jan-14 | ||||
Resolved (Last 7d)= | =COUNTIFS(B5:B8,"RESOLVED",C5:C8,">=A1") | |||
Ticket # | Status | Resolved Date | ||
52146 | OPEN | |||
52148 | RESOLVED | 3-Jan-14 | ||
52159 | RESOLVED | 5-Jan-14 | ||
52180 | RESOLVED | 1-Jan-14 |
<tbody>
</tbody>
Thanks in advance for the help!
Chris J.