relative date appearance

  • Thread starter Thread starter pbtpbtpbt
  • Start date Start date
P

pbtpbtpbt

I am working on a project tracker in which relative dates are
calculated. For example, Column C's formula is =B(row #) +7,
indicating that the date in Column C is the date in Column B plus
seven days. Because this is a project tracker, information will be
added to the spreadsheet as new projects come along. If I drag the
formula down so that it will be available for future projects, the
cells read 1/0/1900. Is there a way I can have the formula in place
for future projects but leave the cell in which it resides blank?

Thanks.
 
I am working on a project tracker in which relative dates are
calculated. For example, Column C's formula is =B(row #) +7,
indicating that the date in Column C is the date in Column B plus
seven days. Because this is a project tracker, information will be
added to the spreadsheet as new projects come along. If I drag the
formula down so that it will be available for future projects, the
cells read 1/0/1900. Is there a way I can have the formula in place
for future projects but leave the cell in which it resides blank?
Click to expand...

=if(b2="","",b2+7)
 
Back
Top