Do you mean a missing date

=IF(OR('Raw Data'!E3="",'Raw Data'!F3=""),"",N(ABS('Raw Data'!F3-'Raw
Data'!E3))/$J$1)

or a date of #NA()

=IF(OR(ISNA('Raw Data'!E3),ISNA('Raw Data'!F3)),"",N(ABS('Raw Data'!F3-'Raw
Data'!E3))/$J$1)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"PAL" wrote in message
...
I am calculating the time between two dates. In the formula, I account for
the dates being reversed by a conditional. Sometimes the data points are
"N/A" if there shouldn't be a date. The formula below returns a "#VALUE!"
error. Is there a way using IFERROR to return a blank?

=IF((('Raw Data'!F3-'Raw Data'!E3)/$J$1)0,('Raw Data'!F3-'Raw
Data'!E3)/$J$1,"")

Thanks.