Dear experts,
As I am not seeing the solution, I wanted to ask you experts if you could help me out.
This is my current formula working with dates:
=IF(W927>V927;"DELAYED DELIVERED";IF(ISBLANK(W927);IF(TODAY()>V927; "NOT YET DELIVERED (LATE)";"NOT YET DELIVERED");"DELIVERED WITHIN LEADTIME"))
V= Expected delivery date
W = Delivery date (returned from another sheet, so it might return a result that is blank as it might not have been delivered yet, but then returns 00-Jan-00 or if no data #N/A.
It works like a charm for most.
However when cell "W" returns from another sheet, that has a blank date field, the value 00-Jan-00 it provides the result "DELIVERED WITHIN LEADTIME".
However i would expect the return "NOT YET DELIVERED" or "NOT YET DELIVERED (LATE)" depending on today's date being later or earlier than cell "V".
With the return of #N/A it perfectly provides "NOT YET DELIVERED"
It's just not working with the 00-Jan-00
Ad I tried so many things, but I just do not see it unfortunately.
Any advice here that I could maybe use?
Appreciated your support already!
Thank you!
As I am not seeing the solution, I wanted to ask you experts if you could help me out.
This is my current formula working with dates:
=IF(W927>V927;"DELAYED DELIVERED";IF(ISBLANK(W927);IF(TODAY()>V927; "NOT YET DELIVERED (LATE)";"NOT YET DELIVERED");"DELIVERED WITHIN LEADTIME"))
V= Expected delivery date
W = Delivery date (returned from another sheet, so it might return a result that is blank as it might not have been delivered yet, but then returns 00-Jan-00 or if no data #N/A.
It works like a charm for most.
However when cell "W" returns from another sheet, that has a blank date field, the value 00-Jan-00 it provides the result "DELIVERED WITHIN LEADTIME".
However i would expect the return "NOT YET DELIVERED" or "NOT YET DELIVERED (LATE)" depending on today's date being later or earlier than cell "V".
With the return of #N/A it perfectly provides "NOT YET DELIVERED"
It's just not working with the 00-Jan-00
Ad I tried so many things, but I just do not see it unfortunately.
Any advice here that I could maybe use?
Appreciated your support already!
Thank you!
