COUNTIFS with Due Date and Status

PR

Hi! I've been trying to use a COUNTIFS formula to determine how many projects are 5 days out from the due date, as well as, which projects are either blank or In Progress. I definitely don't have the formula formatted correctly so it is not working.

Any help you can provide is greatly appreciated!

Paul Newcome

So to be clear...

You want to count all Statuses that are blank or in progress and within the next 5 days? If that is the case, here is a solution...

=COUNTIFS(Status:Status, OR(@cell = "In Progress", ISBLANK(@cell)), [Due Date 1]:[Due Date 1], AND(@cell >= TODAY(-5), @cell <= TODAY()))

Paul Newcome

For the due date...

=COUNTIFS([Due Date 1]:[Due Date 1], AND(@cell >= TODAY(-5), @cell <= TODAY()))

For the status...

=COUNTIFS(Status:Status, OR(@cell = "In Progress", ISBLANK(@cell)))

PR

Thank you, @Paul Newcome. If I wanted to combine these formulas so it is counting each task that's due date is within five days and it is in progress/blank, which formula would come first? I have a really hard time with the structure of formulas.

Thank you again for your help!

Paul Newcome

So to be clear...

You want to count all Statuses that are blank or in progress and within the next 5 days? If that is the case, here is a solution...

=COUNTIFS(Status:Status, OR(@cell = "In Progress", ISBLANK(@cell)), [Due Date 1]:[Due Date 1], AND(@cell >= TODAY(-5), @cell <= TODAY()))