In this sample worksheet all I am trying to do is if a product hasn't arrived instead of the cell returning in Column J -45470 days to maybe just have "Not Arrived" in the cell. Formula works great when product actually does arrive.
Here is the worksheet You can see my attempts
Worksheet shared
Thanks in advance.
Here is the worksheet You can see my attempts
Worksheet shared
Thanks in advance.