# Formula to show the number of items that meet 2 criteria

Options

I am looking to tally up the number of tasks that meet the following criteria:

• Don't have a check in the column "Done"
• Have a due date within the next 14 days

I am actually going to create 3 buckets (due within the next 14 days from today (whenever it's opened), due between 15 and 30 days and due in over 30 days).

I tried this formula but it's "#UNPARSEABLE". I tried using @row instead of selecting rows 1 - 36 but was having issues with that so I just picked a range for testing purposes.

Any tips where I am going wrong?

=COUNTIFS(Done1:Done36, =0, ([Due Date]1:[Due Date]36, <=TODAY(14))))

• ✭✭✭✭✭✭
Options

Try

=COUNTIFS(Done1:Done36, 0, [Due Date]1:[Due Date]36, <=TODAY(14),[Due Date]1:[Due Date]36, >=TODAY())

You do not need the equals and the brackets around the second condition

You could add greater than equal to Today() so as to not include previous dates, also if you want to have the range as the whole columns remove the row numbers

=COUNTIFS(Done:Done, 0, [Due Date]:[Due Date], <=TODAY(14),[Due Date]:[Due Date], >=TODAY())

• ✭✭✭✭✭✭
Options

Try

=COUNTIFS(Done1:Done36, 0, [Due Date]1:[Due Date]36, <=TODAY(14),[Due Date]1:[Due Date]36, >=TODAY())

You do not need the equals and the brackets around the second condition

You could add greater than equal to Today() so as to not include previous dates, also if you want to have the range as the whole columns remove the row numbers

=COUNTIFS(Done:Done, 0, [Due Date]:[Due Date], <=TODAY(14),[Due Date]:[Due Date], >=TODAY())