Countif for Days Elapsed between two dates

karizimmeran

Hi - I have a tracking sheet - it logs date when we receive a request and then a date when the request is fulfilled. I need to calculate how many rows in my sheet where the date rec'd to date of completion is 5 days or less - I'm doing this in a Sheet Summary field.

I asked the AI for a formula and it gave me this:

=COUNTIFS([Date Received]:[Date Received], ISDATE(@cell ), [Date Completed]:[Date Completed], ISDATE(@cell ), ([Date Completed]:[Date Completed] - [Date Received]:[Date Received]) <= 5)

However, when I plug it in, I get the message "INCORRECT ARGUMENT SET." Can you tell me what I am doing wrong? It's too tricky for me to try to figure out myself. :)

Thanks!

Melissa Yamada

The easiest fix is to create a helper column for the turnaround days, for example:

=[Date Completed]@row - [Date Received]@row

Then in your Sheet Summary use:

=COUNTIFS([Date Received]:[Date Received], <> "", [Date Completed]:[Date Completed], <> "", [Turnaround Days]:[Turnaround Days], <=5)

This will count all rows where both dates exist and the completion time is 5 days or less. Helper columns usually make these types of summary calculations much easier to manage.