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!

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
--
Brevity is the soul of wit.


"Maria" wrote:

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!

Maria wrote:
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

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

Tools - options - view - uncheck zero values

Regards,

Jaleel

"Dave F" wrote:

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
--
Brevity is the soul of wit.


"Maria" wrote:

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!