G
Guest
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
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 ifthere 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