I am looking for some support regarding the below issue.
|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