I posted a previous question about a complicated formula, but I believe I
have and idea on how to fix it. Thing is I need as much help as I can get
with thisso please any one with suggestions fill free to send a reply. I will
attach my previous post to this so you all have the information. I decided
rather then to come up with a formula that would keep the "late" or "on time"
reading there why not make a new column that you can enter the new due date
as ( thanks for the suggestions everyone :-)!!!) Thing is I was wondering if
there is a way I can make a formula that if the proof completion date is late
I can set it up so that the number in that column is 4 days after the number
in the completion column. Heres and example. In the due dat column the due
date was 6/12/06 and in the proof completion column the completion date was
the 6/10/06. I have the formula in that column set up so if it is not 4 days
before the due date it is late so in the next column ( status column) it will
read "late". The next column over would be the column that would have the new
due date if the the proof was late. I hope that makes sense to everyone.
PLEASE PLEASE help. I will attach my previous post in case you need more
info.
Previous post:
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!