Search results for query: *

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...

ok got it working now. :) next step is how can i make the number of days a variable so the user can enter how long before to flag up, like perhaps an input box to pop up when user is about to enter a flag date. =IF(TODAY()+7-E3>0,"Late","OK") where 7 is days before item is...

yeah thanks, I was trying to do it in a vb macro as i've only used vb before and not excel/spreadsheet.

what i'm trying to do is flag up in a colunm when an ordered item is late, i.e. when the delvery date has gone beyoned the expected delivery date and also to try and flag up an order a short time it is due so as to see when its expected.

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.