Column showing "overdue"?

[StargateFanFromWork]

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! D

 

[Ian]

With date in A1 and target date in B1.

=IF(B1>A1,B1-A1&"day(s) overdue","")

 

[PaulD]

: 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! D

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