"StargateFanFromWork" wrote in message
...
: A colleague just came to ask me re this and I'm not advanced enough in
my
: vb skills at all, but thought I'd find out for her anyway.
:
: She'll have a column showing a date. In another column, it'll have a
target
: date. I'm guessing that in a third column, she could have a formula so
that
: all rows that have the one date "overdue", i.e., that is going past that
due
: date, will show something. Either text saying "overdue", or even better,
"1
: day(s) overdue", the "1" being replaced by however many days they are past
: due.
:
: Is this do-able? What would be best approach, does anyone feel?
:
: Thank you! :oD

Look into the days360 function, pehaps a formula like this would work
=IF(DAYS360(A1,B1)-1, DAYS360(A1,B1) & " Remain", DAYS360(B1,A1) & " Over
Due")
assuming your start date is column A and target date is column B
Paul D