Hi,

Why you have to enter a text instead of date? if you can leave it blank you
have to use this formula: =if(isblank(I2),"",IF(J2-I2<0,"",J2-I2)) but if you
can not leave the cell blank and should to enter a text in it then you have
to use this formula: =if(iserror(J2-I2),"",IF(J2-I2<0,"",J2-I2)).

ps: in the first formula i assumed that the cell I2 is the end date

Thanks,
--
Farhad Hodjat


"mercedes" wrote:

I am keeping count of the difference in days from when we receive something
to when we quote it using the formula: =IF(J2-I2<0,"",J2-I2) since I cannot
have negative numbers running. But on some fields there is no end date so i
have to enter a text in that field (instead of a date) so in my formula
column I get an error message. I need to change the forlua to where it still
counts the way it does right now, but when there is an error I get a blank
cell instead. Please help!!
Thanks!!!