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

cklasson@

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!

Shaine Greenwood

Hi,

You'll want to use COUNTIFS instead. For example,

=COUNTIFS([Due Date]:[Due Date], <= TODAY(7), [Due Date]:[Due Date], >TODAY())

More on COUNTIFS is available in our help center: https://help.smartsheet.com/function/countifs

cklasson@

Amazing! This worked like a charm and was a total life saver. Thank you so much for your help and advice!