Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

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

@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.