If Error, Make 0

Bessie Koch

Hello,

I am having a hard time getting this formula to product a zero instead of an error. The goal is to have a zero produced if there is no date in the Date Processed column.

The Days to Process formula is: =NETWORKDAY([Date Processed]@row, [Date Submitted]@row)

Paul H

Try using ISDATE

=IF(ISDATE([Date Processed]@row), NETWORKDAYS([Date Processed]@row, [Date Submitted]@row), 0)

Paul H

Try using ISDATE

=IF(ISDATE([Date Processed]@row), NETWORKDAYS([Date Processed]@row, [Date Submitted]@row), 0)

Bessie Koch

Perfect! Thank you!!