Thread: Want it to be blank if date has not been added
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Chris Bode[_18_] Chris Bode[_18_] is offline
external usenet poster
  
Posts: 1
Default Want it to be blank if date has not been added

Format cells in column A and B as date and add following formula in cell
B1
=IF(A1="","",A1+7)



Chris
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com




--
Chris Bode
Reply With QuoteReply With Quote