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!