Why isn't this formula working anymore

tmagana

Peggy Parchert

Hello @tmagana

Hope you are well. The formula contains or references an incompatible data type - could you share the formula please?

Thanks Peggy

tmagana

=COUNTIFS({Escalations 2023 Range 1}, <>"", {Escalations 2023 Range 2}, AND(MONTH(@cell) = [Month-12]1, YEAR(@cell) = [Month-12]2))

Paul Newcome

You most likely have blanks and/or non-date values in the range containing the dates. Try some IFERROR statements.

=COUNTIFS({Escalations 2023 Range 1}, <>"", {Escalations 2023 Range 2}, AND(IFERROR(MONTH(@cell), 0) = [Month-12]1, IFERROR(YEAR(@cell), 0) = [Month-12]2))