How to COUNTIFS when cell is blank and not today.

I need to know how to return a value by these parameters.

  1. There is a column named Completion Date. If it is blank, I need it counted.
  2. I need it to look at another column named Service Date and count if that date is in the past (not today or in the future).
  3. So, I just need it counted if it is blank and earlier than today.

=COUNTIFS([Completion Date]:[Completion Date], ISBLANK(@cell), AND([Service Date]:[Service Date], < TODAY(@cell)))

I keep getting a #UNPARSEABLE error.

Please help.

Thank you

Best Answers