Empty Date Cell as Zero riprussell[ at ]aol.com 22.09.2006 00:01:27 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(A1>0,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

Re: Empty Date Cell as Zero "Bernard Liengme" <bliengme[ at ]stfx.TRUENORTH.ca> 22.09.2006 00:09:13 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 <riprussell[ at ]aol.com> wrote in message news:1158883287.242956.255270[ at ]e3g2000cwe.googlegroups.com... [Quoted Text] >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(A1>0,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 >