Lots of threads like this, but not answer my problem. I tried to explain in a previous post, but my logic was wrong and I'm not authorized to edit my posts.
My issue is similar in that I have two columns; Date of Request and Status of Request. For those requests in a PENDING status, I want to see how many requests are more than 90 days old and less than 180 days old.... The hope is to get a count of the requests that fall in that range....
Column P has the dates of the Requests
Column Q has the status of the requests.
A formula that looks at rows with PENDING in the Status column, then counts those Dates that fall within >90 and <180.
=COUNTIF(AND(Q:Q,"PENDING",P:P,">"&TODAY()-90 AND "<"&TODAY()-180
This doesn't work I know, but the solution should be something similar, right?
My issue is similar in that I have two columns; Date of Request and Status of Request. For those requests in a PENDING status, I want to see how many requests are more than 90 days old and less than 180 days old.... The hope is to get a count of the requests that fall in that range....
Column P has the dates of the Requests
Column Q has the status of the requests.
A formula that looks at rows with PENDING in the Status column, then counts those Dates that fall within >90 and <180.
=COUNTIF(AND(Q:Q,"PENDING",P:P,">"&TODAY()-90 AND "<"&TODAY()-180
This doesn't work I know, but the solution should be something similar, right?
