Forum Discussion
How to make uncalculated dates blank
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...
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.