Level 2 sprint 3 3.3.5 confirmed Po delivery formula

[Vam1992]

I have used formula for confirmed PO delivery line item IF PO submitted =1 Then OFFSET(PO Submitted ,shipping time weeks ,0)Else 0 but this formula is not giving desired result of offsetting PO submitted in confirmed PO delivery..attached the screen shot for the issue please help me out on this

[mebby2k]

according to the logic, on your screenshot, for week 3, po submitted = 0, then what should be the value of confirm po delivery for that week?