Date cell format
Thanks...Dennis
"Myrna Larson" wrote in message ...
=IF(B40,B4+180,"")
On Fri, 10 Sep 2004 18:42:04 -0400, "Dennis Allen"
wrote:
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
|