COUNTIF Formula for Only Showcasing What is Due to Upcoming Week Period

edited 12/09/19 in Formulas and Functions

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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!