Another one for you...
Column J represents - expected delivery date
Column K represents - Delivery status
Column L represents - actual delivery date
currently the cells in column K the formula is =IF(J6="","",IF(J6>=O2,"Awaiting Delivery","Delivery Outstanding!"))
Cell ref O2 is the =NOW() function
I would like column K to also say Delivered when a date is inserted into column L.