Date cell format
Hi again. There's a problem. If I have D5 with the formula =IF(B40,B4+180,""). then another column with a formula
=IF((D50)*(F5(D5+180)),"PAST DUE","-") it won't work. How can I use D5, which might be a date or a ""?
"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
|