COUNTIF Formula Question
I'm trying to determine a COUNTIF formula to show what deliverables are due in the next 7 day period based upon a Due Date column. However, I'd like said formula to only showcase what deliverables are in the next 7 days and ALSO be able to EXCLUDE all projects that become overdue.
So essentially I'd like a COUNTIF formula to only showcase what documents/projects are due within the next seven day time span.
So far I have come up with the following equation. It works, however I'm failing to make it also exclude any projects whose due dates fall out of said due date period. It will continue to showcase deliverables that technically are overdue, which I'd like to exclude, as I already have an overdue column.
=COUNTIF([Due Date]:[Due Date], <TODAY(+7))
I was wondering if anybody had any suggestions, as I have completely exhausted my idea bank. Thanks!
Comments

Just time for a quick note. Try using two COUNTIF functions in the same formula. The first could count everything in the future then subtract another COUNTIF that looks a week out and farther.
To eliminate counting items that are overrunning use the COUNTIFS function instead and only count items that are not overrunning.
Sorry, I don't have more time to be more specific.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.9K Get Help
 379 Global Discussions
 208 Industry Talk
 441 Announcements
 4.5K Ideas & Feature Requests
 139 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 297 Events
 33 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!