Need to add the year to this formula?

jcepon

=COUNTIFS([Date Received]:[Date Received], IFERROR(MONTH(@cell), 0) = 5) I would like to count these months by the year? How do I add the year to this string?

Thanks

Jeff Reisman

Try using an AND statement to count Date Received when the month = 5 AND the year = 2022.

=COUNTIFS([Date Received]:[Date Received], AND(IFERROR(MONTH(@cell), 0) = 5, IFERROR(YEAR(@cell), 0) = 2022))