Not showing column blank when there is no record in the column

[Anonymous]

I am working on below query where I want show the status based on the comparisio between  dates in two column.When  a row in "Promised Receipt Date" column does not have any record ,I want it either remain blank or give a specific message in "Status " column but in this case ,it gives "Shipment Ahead Of time" as status.If someone cant help me fix below query.

Status = IF(([Promised_Receipt_Date]<[Expected_Receipt_Date]),"Shipment Ahead Of time", IF([Promised_Receipt_Date]>[Expected_Receipt_Date],"Late Shipmemt Promise", IF([Promised_Receipt_Date]=[Expected_Receipt_Date],"Shipment Just On Time", If(ISBLANK([Promised_Receipt_Date]),"No Promised Receipt Date"))))

[Anonymous · Accepted solution]

Hello @Anonymous ,

Put Isblank condition first, 

If its not blank then it will go for comparison conditions.
Status =
            IF(ISBLANK([Promised_Receipt_Date]), "No Promised Receipt Date",
                IF( [Promised_Receipt_Date] < [Expected_Receipt_Date] , "Shipment Ahead Of time",
                   IF([Promised_Receipt_Date] > [Expected_Receipt_Date], "Late Shipmemt Promise",
                       "Shipment Just On Time" )
       ))

Best Regards,
Nirav