How to make uncalculated dates blank

Copper Contributor

Im using this formula "=Q32-TODAY()"

But for some of the cells I don't have dates currently so the formula returns with several pound signs (#). I want to add another formula to ensure blocks that generate #'s appear blank. Any suggestions?

1 Reply



Assuming you mean some of the cells in column Q are currently blank, so you don't want this formula to be calculated and the results displayed, try this (copied down whatever column it is that contains that formula now).


If my assumption is wrong, though, come back with a more complete description, maybe a sample of the spreadsheet itself.