formula help

[Guest]

I have a worksheet that will not have dates entered until applicable and I am
trying to have the formulated cells remain blank until the date is entered.
However at this point it is showing 1/5/00.

Any suggestions?

Dione

 

[Guest]

What's the formula you're referring to that yields 1/5/00?

Without knowing the formula you're talking about it's impossible to tell you
how to have it return a blank.

Dave

 

[Guest]

Thanks Dave,

I actually figured it out on my own.