COUNTIFS help for future dates
I wanted to create summary tasks for items that are past due and then items that are upcoming in the next 30 days.
My Past Due formula is working correctly:
=COUNTIFS([End Date]:[End Date], <TODAY(), [% Complete]:[% Complete], <0.1)
My Upcoming tasks formula is not:
=COUNTIFS([Start Date]:[Start Date], <=TODAY(+30), [% Complete]:[% Complete], <0.1)
It should be returning the same number that I see in the filter which is 108 rows, but it is returning 391 rows. I'm stumped
Help Article Resources
Check out the Formula Handbook template!