@smithevan18 Please refer to the details below: a) Confirmed PO Delivery = OFFSET(PO Submitted, -Final Shipping Time Weeks, 0) b) Confirmed PO Delivery Test = POST(PO Submitted, Final Shipping Time Weeks) With the above formulas, the results are as in Diagram 1. Am trying to understand why Confirmed PO Delivery is in Week 6 instead of 7 or is it supposed to be in Week 6. Essentially, am trying to understand the difference between OFFSET and POST. It will move to Week 7 if the formula is changed to OFFSET(PO Submitted, -Final Shipping Time Weeks - 1, 0) -> Diagram 2
... View more