If statement excluding cells with non-numeric values

Good morning,

I am working on a spreadsheet that has dates in 2 columns. In a third column I have placed a formula that will display the umber of days elapsed between the two, only if there is a date in both referenced cells. This is the formula I have, that works well: =IF((AND(L8>0, H8>0)), L8-H8, " ")

The last step that I cannot figure out is how to display nothing (" ") if there is something other than a date, or numeric value in one of the date cells. For example, the folks that keep the spreadsheet up to date with put "----" in the cell if there is not a date. How can I edit the above formula to not display an error if one of the date cells contains a non-numeric value?

Thanks in advance.

You could do it this way:

IF(AND(ISNUMBER(L8), ISNUMBER(H8)), L8-H8,"")

Note there should not be a space between "".

Hope this helps.

Pete

thank you! the IFERROR() FUNCTIONED worked!