COUNTIF date is this month in Summary Sheet

aelmore33

Hello!

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!

Mike TV

@aelmore33

Try using this:

=COUNTIFS([Response Date]:[Response Date], >=TODAY(), [Response Date]:[Response Date], <=TODAY(30))