CALCULATING DATES

  • Thread starter Thread starter spudpeeps
  • Start date Start date
S

spudpeeps

can anyone help me! i have created a gantt chart, but having the following
problem: column A contains qty of days, column B is start date, column C is
end date. i have set column C so that it adds column A + column B to give me
an end date, but if there is no start date, the end date displays 05/01/00.
A B C
E.g: 6 + (05/12/07) = 10/12/07 ( formula i am using or (C ) is =A+B+1)
6 + ( ) = 05/01/00 ( i want this to remain blank until i
put a start date
in as i have copied the formula down the cells of column C
any ideas???
 
Change the formula in C1 to the following:

=IF(B1="","",A1+B1+1)

Then copy and paste down column C as far as you need it.
 
WLMPilot said:
Change the formula in C1 to the following:

=IF(B1="","",A1+B1+1)

Then copy and paste down column C as far as you need it.
Click to expand...
thank you so much
although this solved the above problem, it has now caused another problem,
my fault i did not say what i was working on, i have created a gantt chart
in excel
and use the start and end dates to calculate work progress and for every day
counted in the end date, a designated cell will be highlited through out the
month.
the above formula you have sent has caused the whole of the month to be
highlited,
what i want is for the whole range of cells for that month to also remain
blank until the start date is entered.....
 
Still not sure what you are trying to do. Can you explain the "range of
cells" by using cell examples and what they are to do. I may be able to help
you better then.
Also, explain your original formula: What is the qty of days and how do you
determine that value. Also, why is "1" added to the formula?

Thanks,
Les
 
Back
Top