CountIfs Dates with ISBLANK

Rigoberto Huizar

I am having  trouble with my formula.  A portion works but as soon as I insert the IF and ISBLANK Statement it Fails. I want the formula to use the "Actual Plan Actual Finish" column and if that is empty then use the "Action Plan Finish Date". I'm not sure where to insert that piece of the formula. Any help would be appreciated.

=COUNTIFS({Action Plan Request Date}, IFERROR(WEEKNUMBER(@cell), 0) <= [1]1, {Action Plan Actual Finish}, IFERROR(WEEKNUMBER(@cell), 0) >= [1]1, {Action Plan Finish Date}, IFERROR(WEEKNUMBER(@cell), 0) >= [1]1, {Action Plan Actual Finish}, IFERROR(WEEKNUMBER(@cell), 0) >= [1]1)

Paul Newcome

You would need to add two separate COUNTIFS together to accomplish this. The second would include the criteria of {Action Plan Actual Finish} being blank.

=COUNTIFS(Action Plan Request Date}, IFERROR(WEEKNUMBER(@cell), 0) <= [1]1, {Action Plan Actual Finish}, IFERROR(WEEKNUMBER(@cell), 0) >= [1]1) + COUNTIFS({Action Plan Request Date}, IFERROR(WEEKNUMBER(@cell), 0) <= [1]1, {Action Plan Actual Finish}, @cell = "", {Action Plan Finish Date}, IFERROR(WEEKNUMBER(@cell), 0) >= [1]1)