COUNTIF date is this month in Summary Sheet


I'm trying to count the number of pursuits that are due("Response Date" column) in the next 30 days. I'm currently using this formula in my Summary Sheet:

=COUNTIFS([Response Date]:[Response Date], =MONTH(TODAY() + 30))

But, it's not working. Can someone please help?

Thank you!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!