Empty Date Cell as Zero
 

I am trying to tie a formula to a cell that contains a starting date.
However, when this "starting date" cell is empty, I want the
corresponding formula to read it as zero. Because the "starting date"
cell is formatted as a date, the corresponding formula seems to still
show blank cell as having a default date in it, and returns a value for
that cell.

How can I make this blank cell be read as "null" or void of data to the
cooresponding formula?

Here's the detail:

A1 The Cell a Date Would Be Input (currently blank)
A2 The formula: IF(A10,A1,0)

Currently, the formula returns a value of "1/0", which is the current
month/day format of the blank cell. I want it to return "0", since no
data is in A1.

Thanks!!

~Rip

Empty Date Cell as Zero
 

Try this: =IF(ISBLANK(A1),"0",A1) and right align the cell
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

wrote in message
ups.com...
I am trying to tie a formula to a cell that contains a starting date.
However, when this "starting date" cell is empty, I want the
corresponding formula to read it as zero. Because the "starting date"
cell is formatted as a date, the corresponding formula seems to still
show blank cell as having a default date in it, and returns a value for
that cell.

How can I make this blank cell be read as "null" or void of data to the
cooresponding formula?

Here's the detail:

A1 The Cell a Date Would Be Input (currently blank)
A2 The formula: IF(A10,A1,0)

Currently, the formula returns a value of "1/0", which is the current
month/day format of the blank cell. I want it to return "0", since no
data is in A1.

Thanks!!

~Rip