Hello everyone,

I have a problem.
In my sample workbook you can see the on-time column is set up to Yes or NO
based off whether the due date is earlier than the current date and if "Sent to Customer" appears in the notes column.

I need to be able to put Sent to Customer and the date it was sent in the notes column without messing up the On-time column.

For instance in my sample workbook, I have "Sent to Customer 07-09-14" in the notes column this should be considered on-time.
But I don't know how to tell the On-time column to ignore/accept the date since each date will be different.

Is there a way to do this?
Thanks in advance for any and all assistance!

Sample Workbook.xlsx