COUNTIFS with month and year

The data that I have is on the Date:Date column. I want the formula to return the amount of cells that meet the month and year criteria. I have the following formula and I'm not sure what's wrong but it gives the #unparseable error. I have tried many different formulas from other posts but can't get it right.

=COUNTIFS(Date:Date, IFERROR(MONTH(@cell), 0) = 6), IFERROR(YEAR(@cell), 0)=2022))



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!