Invalid Data Type

Robert S Fike

Can anyone help with this formula.

Jason Tarpinian

You can just wrap it all up in an IFERROR to get rid of the #ERROR.

=IFERROR(IF(ISBLANK([Pre-Sale Contract Date (TBD Convert)]@row), NETDAYS([Lot Hold Date]@row, TODAY()), NETDAYS([Lot Hold Date]@row, [Pre-Sale Contract Date (TBD Convert)]@row)), "Missing Dates")

Then if any of the dates are missing it would return "Missing Dates" instead of the error message.