relative date appearance

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.
 
J

Jordon

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calculate total hours based on dates 5
How to a Time planning into pivot table . 1
calculation based on the range you indicate in another cell 2
Formula to fill cells based on Date of Arrival and Date of Departure 1
Sumproduct function allow a lookup for one Date to check if it fallsin Date Range in other table 9
How to count/summarize multiple Criteria - URGENT ASSISTANCE NEEDEDPLEASE!!!!! 2
Excel lookup across entire workbook 1
Array to find relative position - is there a better way? 3

Top