Make it disappear!

[jackdiamond]

Hi,

When you have a formula that is awaiting some more info, sometimes it shoes DIV or in my case -40302 ( I am dealing with dates)

Does anyone know how to make this invisable until the calculation is complete please?

Any help appreciated

Ta
Stu

 

[GlennUK]

And your formula is?

 

[VoG]

Hi. Try like this

=IF(A1="","",A1-TODAY())