in ref. to my previous post:
thread707-598788 I4 is Arrived column , E4 is Delivery date column , F4 is a flag time column
this function displays a flag, late or ok in a Status column and arrived in a delivery column if object has arrived.
how can i go about making it so the status and...
is there a way to check seperate columns in excel , date ordered, date required, date arrived - against each other and flag up when a date required exceeds date arrived or perhaps a couple of weeks beforehand.
there may be lots of rows so i need an efficient way of checking.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.