text and dates


Posted by Ronni on October 26, 2001 9:23 AM

Hi, Please Help me!
If cell C5 contains a sent date such as 10/27/01 and Cell d5 contains the text "submitted" when no actual date is available because it was done online. What formula would I use in cell E, which would have given me the number of days lapsed from the date received(Column d) to date sent(Column c). The formula I'm using is IF(D5, D5-C5,""). Since 2 dates are not available how can I get it to ignore the text and not give me the "#value!"error. Is there a possible solution to this, I have tried EVERYTHING!



Posted by Barrie Davidson on October 26, 2001 9:26 AM

Try something like this:


=IF(ISNUMBER(D5),D5-C5,"").

BarrieBarrie Davidson