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???