Hide formula result values until all components are entered

[Guest]

I have a column with a formula to calculate a date based on a date entered in
the previous column. I want the result in the column to be blank until the
date is entered. Now it reads 01/01/00 until I enter a date for it to
calculate correctly. Please help!

 

[Guest]

You have to trap the error, or date in this case, but it's impossible to tell
you how to do that without you giving us the formula.

Dave

 

[Franz Verga]

I have a column with a formula to calculate a date based on a date
entered in the previous column. I want the result in the column to
be blank until the date is entered. Now it reads 01/01/00 until I
enter a date for it to calculate correctly. Please help!

Hi Maria,

I think you could try something like this:

=IF(AND(A2<>"",A2<>0),your_formula,"")

where A2 is the cell where to input the date to calculate. Adapt references
as for your conveniences.

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

 

[Guest]

01/01/00 indicates 0 in a date formatted cell. Why can't you try this:

Tools - options - view - uncheck zero values

Regards,

Jaleel