There appears to be a problem with the formula determining whether a doc has been delivered on time.
Three days ago I submitted some docs on time. I entered the date in the spreadsheet and the On Time flag correctly displayed TRUE.
I opened up the spreadsheet today and the same flag showed FALSE (see attachment). I hadn't changed any data; the only thing that is different is that the due date is now in the past.
Based on testing, if the due date is in the past or is the current date, the flag displays as FALSE even if the doc was submitted on time. The formula
=IF(AND([Delivered]=0,[DueDate]>TODAY()),"",AND([Delivered]>0,[DueDate]>TODAY()))
looks like it's using the current date for the comparison, instead of just comparing the delivered date to the due date. I don't understand Excel formulas well enough to edit the thing. What I need is basically
If [DueDate]-[Delivered]=>0, True, Else False
TIA
|