Formula to Count the Number of Tasks that will be due within the next 5 days

Paul Newcome

Happy to help. 👍️

Jessica Griffin

=COUNTIF({Template -Tasks Range 1 - Due Date}, <=TODAY(7)

I have this working, however how do I add Only if Status is not complete?

Paul Newcome

@Jessica Griffin

Try this...

=COUNTIFS({Template -Tasks Range 1 - Due Date}, <=TODAY(7), {Other Sheet Status Column}, @cell <> "Complete")

Using the COUNTIFS function (with the "S" on the end) allows you to include additional range/criteria sets.

"<>" means "not equal to".

SteelRed1

@Paul Newcome - sorry, I know this is an old thread. I'm trying to do something similar to Jessica but I can't get it to work.

=COUNTIFS([Due Date]:[Due Date], AND(@cell >= TODAY(), @cell <= TODAY(+7)), (Status:Status, (@cell <> "Completed")))

I can get the formula to work without the added criteria. So I know that's where the problem lies.

Any help would be great.

Paul Newcome

@SteelRed1 You have some unnecessary parenthesis.

=COUNTIFS([Due Date]:[Due Date], AND(@cell >= TODAY(), @cell <= TODAY(+7)), Status:Status, @cell <> "Completed")

SteelRed1

Duh! Thank you.

Paul Newcome

@SteelRed1 Happy to help. 👍️