Formula that will automatically detect if it has passed the due date

Hi,

I need a formula that will determine the status depending on how many days are left before the due date.
I have this formula:

Please Login or Register  to view this content.

This formula works fine but at the moment it only says "Delivered" when date is being entered in column B
I need to show "Delivered - late" if it has been delivered passed the due date.

Hi Elaine

I am attaching an updated spreadsheet for you.

I have added 3 items to your spreadsheet :
1) to calculate the difference between deadline (Scheduled) and Delivery (Actual)
2) a table in which you enter the criteria for your reporting I have included a "large" value of -30 to allow for delieries being very efficient otherwise you have a slight glitch.
3) a vlookup of the nett of (actual-deadline) in the table to give you the answer.

Hope this helps
Ian

Hi Ian,

Thanks for your reply, the problem with the solution you have made is that it says only "Overdue".
When it has been delivered even though it is overdue it should say "delivered - overdue" or if delivered in time then it should show "delivered - in time"

Hi Elaine,

If you look in the area F13:G17 you will see on the left the number for determining the comment and in Column G the comment you are looking up.

You can change the comment to "Delivered - Overdue" and the lookup works automatically.

Hope it helps
Ian