View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Dennis Allen Dennis Allen is offline
external usenet poster
 
Posts: 43
Default Date cell format

Thanks...Dennis

"bigwheel" wrote in message ...
Change the formula to =IF(B40,B4+180,"") which will make the cell blank

"Dennis Allen" wrote in message
...
Hi. In a date column, if I leave the cell empty nothing is displayed. If

I add a formula =IF(B40,B4+180,0), however, I get
1/0/1900. Question. Is there any way to surpress 1/0/1900? If there's

no value, I want to see an empty cell. Thanks for any
advice...Dennis