Hi

One way:
Rename date column you have now as PlannedDueDate. Beneath it add another
column named as ActualDueDate. When PlannedDueDate was p.e. column B, then
into C2 enter the formula
=IF(B2="","",B2)
, and copy it down (you can have this formula ready waiting for an entry
into another column). Whenrever you enter planned due date, the same date is
displayed as actual due date too.

Now when the work will be late, then overwrite the formula with new date -
you will have different planned and actual due dates for this work.

In formulas referring to due date, you have now to decide, which one you
have to refer to. P.e. in status formula, you have to refer to planned due
date - the work will be late anyway when planned due date is missed.


Arvi Laanemets


"babiigirl" wrote in message
...
In adding that new column why does it disable the status column then? Do I
need to change something in my formula?

"Tim M" wrote:

This may or may not be possible for you but I would just insert another
column in the sheet to enter the 2nd date. That way you would not be
affecting the formulas as you have outlined. This column would only
have
date data in it if that particular entry was 'Late'

"babiigirl" wrote:

I am working on a microsft excel spreadsheet for my boss( excel 2000).
We are
working on a spreadsheet dealing with a lot of formulas. I have one
column
that tells whether a work is lat eor not. This formula automatically
enters "
late" or "on time" which is great, but if a work is late then i must
chnage
the date in one of the columns so I know the actual due date. The
problem is
the column I must change the due date is one of the ones in the
formula for
the status column and when I change that date for our records it
automatically changes the work to on time when in reality it wasn't. I
was
wondering if there is any way that after I enter that inital date if I
can
get the status to stay at either "late" or "on time" and it will not
chnage
when I change the new due date. Is there a way I can adjust the
formula to
this?
This is the formula I am using for the status =IF(TODAY()<=L75, "On
Time","Late"). This is the formula for the due date =W75-4. Please
help if
you can!