COUNTIFS - using a date

Question

Hi - looking for help with what I think would be an easy formula.

What I want to do is create the number of "Complete" tasks I have that are due BEFORE 3/31/2021.

Can anyone help with my formula and point out an error? I get UNPARSEABLE as a result.

=COUNTIFS(Status2:Status571, "Complete", [Due Date2:DueDate571,<"3/31/2021")

Thanks so much!

Lynda🧐

Mark Cronk · Accepted Answer

=COUNTIFS(Status2:Status571, "Complete", [Due Date]2:[Due Date]571, AND(ISDATE(@cell), @cell<DATE(2021, 3, 31)))

Mark

Mark Cronk · Accepted Answer

Glad you found a solution. Happy to help. You had a couple syntax errors. I added the ISDATE to avoid getting an error.

Thanks for contributing to the Community.

Mark

Mark Cronk · Accepted Answer

Try this:

=COUNTIFS(Status2:Status571, "Complete", [Due Date]2:[Due Date]571, AND(ISDATE(@cell), @cell>DATE(2021, 3, 31), @cell<DATE(2021, 5, 2)))

Mark

Lynda Ross · Accepted Answer

@Mark Cronk - again, fabulous! Thank you so much! I haven't worked with many AND & ISDATE functions so I appreciate your help!

Happy St. Patty's Day!