largest gap between two days of the week

[Deamo]

Hi,

In the attached workbook i have a list of routes, and the days of the week that we deliver to customers on.
In column L i have listed the largest gap between any two delivery days for each route.

What I'd like is aformula that can accomplish this, so i don't have to do so manually everytime the days change.
I figured it'd be easiest to use the weekday function, but i've been unable to figure out a way to calculate the max difference between two days so far.

For example, for route 1210, assuming we receive an order on Friday, it will be delivered the following Tuesday - so 4 days (sat, sun, mon, tues)

The definitions in the data are as follows:
0 = non-delivery day
1 = delivery day

W001 = weekly delivery
W002(E/O) = Fortnightly delivery - the E & O relate to even or odd numbered weeks which can be ignored for the purposes of this thread.
M001 = Monthly delivery.

[FlameRetired]

This works at my end

Please Login or Register  to view this content.

[Deamo]

Brilliant, thanks Dave

[FlameRetired]

You're welcome. Thanks for the feedback, added rep and marking your thread Solved.