formula help
 

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

formula help
 

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


"DRondeau" wrote:

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

formula help
 

Thanks Dave,

I actually figured it out on my own. :)

"Dave F" wrote:

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


"DRondeau" wrote:

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