I have been trying this all day and keep getting Invalid! Hoping someone here can help me write this function. My spreadsheet is a task list - which needs to show what is outstanding and what is completed.



So if C5 = to a date AND E5 = to a date F5 should say COMPLETED
If C5 = a date and E5 is empty should say OUSTANDING


C5 = the date the work was given and E5 is the date the work was completed.


I have separately got a colour code going using conditional formating showing a traffic light system depending on days work is outstanding/overdue etc., but just want to add this final bit in. Your help would be much appreciated - please let me know what format the cell that I put the above function in to should be.