How to make uncalculated dates blank

[ToddPechin44]

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?

[#2]

@ToddPechin44 

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(ISBLANK(Q32),"",Q32-TODAY())

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