I’ve been trying to create a chart which will look at the difference between Promised and Shipped dates, calculate the difference, then plot the highest and lowest value within a given week. To this point I’ve been miserably unsuccessful and could use some help.

So far, I’ve created a formula subtracting the Shipped Date from the Promised Date and called it Days Early or Late. From there I need to create a chart that will capture only the high and only the low but it seems to be adding every instance in a given week rather than isolating the single highest and single lowest occurrence for that week.

Any help would be very much appreciated.

All the best-

Devin