Forum Discussion
How to get a cell with a formula to ignore another cell with a formula that shows up blank
Hello. I am using a Custom Formula in Column B, C, G and H, to format how the date will show on an excel Gantt Chart. My aim is for Column B to calculate 5 days prior to what is in Column C (example...
Use this cell formatting code for your dates in C:
mmm dd yyyy;;;
- Thanks, that is the formatting I have in place already. I think because it is a custom date setting it see it as a data entry, I am not sure. I know that if I ignore zeros on the sheet all the Jan 00 1900 disappear yet it still causes the B column to show hashtags.
That's odd. I'd have to see the sheet. You could try this one:
[<>0]mmm dd yyyy;[=0]""- That was great for removing all the Jun 00 1900 from the Cells in Column C leaving blank, but still the respective Cells in Column B have the hashtags : (
Is there a way to post the sheet for you to view? I will gladly do so.
