How to count by month?

DoDavis

I have a column which contains dates throughout the year as mm/dd/yy. Then i have another column for each month of the year and attempting to CountIF in those columns to capture how many requests came in for that month.

I have attempted =COUNTIF([Request Date]28:[Request Date]33, "March") yet the cell is calculating 0.

Paul Newcome

Try this instead:

=COUNTIF([Request Date]28:[Request Date]33, IFERROR(MONTH(@cell), 0) = 3)

Paul Newcome

Are you able to provide a screenshot for context/reference?

DoDavis

Paul Newcome

Try this instead:

=COUNTIF([Request Date]28:[Request Date]33, IFERROR(MONTH(@cell), 0) = 3)

DoDavis

THAT WORKED LIKE A CHARM!!! Thank you so much!

Paul Newcome

Happy to help. 👍️