Rolling 12 Months CountIFs Statement

I have 3 different dates that I all want counted into a rolling 12 months

Date Set #1 - =COUNTIF({Date Budget #1}, AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2024))

Date Set #2 - =COUNTIF({Date Budget #2}, AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2024))

Date Set #3 - =COUNTIF({Date Budget #3}, AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2024))

I want this to all be in one line for the three sets of dates count if they are within January in 2024.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!