Hello, new guy here!
Its a little "bug" if you will or I dont know how to properly write the formula.
Basically, I want that status cell to read "On Schedule" if the delivery date is blank. But its giving me early, because technically the value of it being blank is less than the due date.
=IF([@[Delivery Date]]=[@[Due Date]],"On Time",IF([@[Delivery Date]]<[@[Due Date]],"Early",IF([@[Delivery Date]]>[@[Due Date]],"Late",IF(C2="","On Schedule",""))))
Hoping someone can point out where I went wrong or where to correct.
Thanks!
Its a little "bug" if you will or I dont know how to properly write the formula.
Basically, I want that status cell to read "On Schedule" if the delivery date is blank. But its giving me early, because technically the value of it being blank is less than the due date.
=IF([@[Delivery Date]]=[@[Due Date]],"On Time",IF([@[Delivery Date]]<[@[Due Date]],"Early",IF([@[Delivery Date]]>[@[Due Date]],"Late",IF(C2="","On Schedule",""))))
Hoping someone can point out where I went wrong or where to correct.
Thanks!