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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"spudpeeps" wrote in message ...
| What formula do i use???
| here is my problem... i have 3 columns
| A- Qty of days eg: 6, B-start date, eg: 10/12/07 C -end date, , (formula i
| am using, (colummn (C) =A+B+1 (copied down the column) this gives me an end
| date by adding A and B which i use in a gantt chart, eg; "but" some dates do
| not have a start date yet and the end result will read (C) 05/01/00, how can
| i get column (C) to remain blank until i put a start date in????
|