Thread: Want it to be blank if date has not been added
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KKJ KKJ is offline
external usenet poster
  
Posts: 3
Default Want it to be blank if date has not been added
This should be simple: In cell A1 there is a date. in cell B2 I want to add
7 days to that date. But if I have not yet added a date in A1 I would like
B2 to stay blank.

I Can't seem to make that happen.

Thank You!!


Reply With QuoteReply With Quote