Hello - I am trying to solve the classic Due Date vs Actual Ship Date question for my shipping department (on time rates).
There are two catches: One, we do not ship on weekends so the formula needs to account for that.
And secondly, the retail channel we are shipping to gets a +3 day buffer allowance. So a shipment that was Due to ship on Jan 15, but actually shipped on Jan 18, is still considered On Time.
I’ve tried DateDiff but it does not work since many of the actual dates precede the due date (early shipments).
I do have a date table. Relationship to the date table is to the Due Date on the Orders table, and the Date Shipped on the Shipments table. But no idea how to account for weekdays only, while also accounting for the +3 day buffer. Help wanted!