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!