1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Formula/Method to display weekdays between 2 listed weekdays for a general weekday order schedule

Our take

Managing delivery schedules across multiple vendors can be complex, especially when their final order "drop" days differ. To streamline this process in Excel, you can create a formula that calculates the weekdays between each vendor's delivery days. For instance, if a vendor delivers on Mondays, Wednesdays, and Fridays, but has varying drop dates, you can automate the identification of auto-order days. This method allows you to visualize the days between drops, ensuring you never miss an order while simplifying your workflow.

Trying to find an easy way to calculate auto-orders between final order days for a delivery.

For example 1 of my vendors may send deliveries on Mon/Wed/Friday, but their final "drop" date that sends those orders may not be the same as another vendor on the same delivery schedule.

Example:

Monday delivery drops final order on Thursday

Wed del drops orders on Saturday

Fri del drops Tues

Working backwards from the "drop" day fills in each nights auto-order included in each delivery. Would there be a way to have Excel fill in that the days between in parenthesis:

-Tuesdays drop (previous drop is Saturday, days between is Sunday, Monday and includes orders from those days as well) delivers on Friday

-Saturdays drop (previous drop is Thursday; days between Friday) delivered on Wed

-Thursdays drop (previous is Tuesday; days between Wednesday) delivered on Monday

Open to other ways, but it would be a huge help to automate this calculation of the weekdays between between vendors instead of just doing each change in my head and typing it in.

submitted by /u/WildDumpsterFire
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article