Counting # rows submitted in a particular month and year

Mallory M.

Hello, my current formula only counts what month a row was submitted but not the year. How can I get the formula to also count the row if it happened in January of the current year?

=COUNTIF({Date Submitted}, IFERROR(MONTH(@cell), 0) = 1)

Carson Penticuff

=COUNTIFS([Date Submitted]:[Date Submitted], IFERROR(MONTH(@cell), 0) = 1, [Date Submitted]:[Date Submitted], IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))

jmyzk_cloudsmart_jp

@Mallory M.

=COUNTIFS({Date Submitted}, ISDATE(@cell), {Date Submitted}, YEAR(@cell) = YEAR(TODAY()), {Date Submitted}, MONTH(@cell) = 1)

Carson Penticuff

=COUNTIFS([Date Submitted]:[Date Submitted], IFERROR(MONTH(@cell), 0) = 1, [Date Submitted]:[Date Submitted], IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))

Mallory M.

@Carson Thank you!😊