Formula for 2024 returning 0

System

This discussion was created from comments split from: Last Month Formula?.

Samantha S.

I'm having the same issue for 2024. I'm calculating the number of audits LM which worked until 1/1/2024 hit and now it shows 0 where it should reflect 805 which is our December result.

Paul Newcome

Try this:

=COUNTIFS({Conducted Date2}, AND(IFERROR(YEAR(@cell), 0) = YEAR(IFERROR(DATE(YEAR(TODAY()), MONTH(TODAY()) - 1, 1), DATE(YEAR(TODAY()) - 1, 12, 1))), IFERROR(MONTH(@cell), 0) = MONTH(IFERROR(DATE(YEAR(TODAY()), MONTH(TODAY()) - 1, 1), DATE(YEAR(TODAY()) - 1, 12, 1)))))