COUNTIF MONTH AND YEAR SAME FORMULA

Options


I just want to make a filter in the formula for month and year, but I'm not getting it, so I just want to filter what is January (1) and the year 2019 for example. the formula below is not working can you help me?



=COUNTIF({COLUMMXX}; IFERROR(MONTH(@cell); 0) = 1) ; IFERROR(YEAR(@cell); 0) = 2019))


thanks

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!