Forum Discussion

ToddPechin44's avatar
ToddPechin44
Copper Contributor
Nov 29, 2023

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 generate #'s appear blank. Any suggestions?

  • mathetes's avatar
    mathetes
    Silver Contributor

    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.

Share

Resources