Count The Number of Upcoming Deliveries Within a Certain Number Days

GeeCil

Hey there!

I've tried everything.

All I am trying to do is produce a formula that counts the number of deliveries we have in a certain number of days that is not in "lost or cancelled" status. This helps us keep our eye on the prize to ensure we are doing all of our tasks prior to the delivery date so the customer can have a great experience.

Two main columns I'm using are "LOAD IN" and "STATUS"

Logic I'm trying to get to produce a number: If the LOAD IN date is in the next 30 days and is NOT in "lost" or "cancelled" status, count number of entries.

Naturally once I figure out this formula, I can use this to go even further into the future (60, 90, 120 days).

Screen Shot 2022-01-23 at 1.28.48 PM.png

Kelly Moore

Hey @GeeCil

=COUNTIFS([Load In]:[Load In], ISDATE(@cell), [Load In]:[Load In], @cell>=TODAY(), [Load In]:[Load In], @cell<=TODAY(30), Status:Status, OR(@cell<>"lost", @cell<>"cancelled", @cell<>""))

Does this work for you?

Kelly