Engineer

Hi,

I am looking for some support regarding the below issue. 

  A B C D Lead Time
Example Wk 36 2019 Wk 50  2020 19


If (CD + Lead Time is less than or equal to AB) then it should give Okay, if not then NOT OK.

I mean in the example shown, Wk 50 2020 + 19 = Wk 07 2021 (considering a calender year has only 52 weeks),  As Wk 07 2021 is not less than or equal to AB (Wk 36 2019) it should say Not Ok.

 

It would be really helpful if someone could help me with this issue.

Operating system – Windows 7

Excel – Office 365

By: Siv

One thought on “Engineer

  1. D N Maru

    Hi..
    Assuming your above data is in A,B,C,D,E cells and in rows 1 & 2; please put following formula in cell F2

    =IF(D2+VALUE(RIGHT(C2,2))/52>B2+VALUE(RIGHT(A2,2))/52,”NOT OK”, “OK”)

    I assume there are no trailing spaces in your data.

    Please do let me know if you don’t get it.

    Thanks

Leave a Reply

Your email address will not be published. Required fields are marked *