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
|