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