Count The Number of Upcoming Deliveries Within a Certain Number Days
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).
Answers
-
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
Help Article Resources
Categories
Check out the Formula Handbook template!