How can I create a NETWORKDAYS formula that results in a blank field until an End Date is specified?

Katherine Wilgruber

I need a column to show =NETWORKDAYS(([Start Date]@row), ([End Date]@row)), but currently the rows where End Date is blank are returning #INVALID DATA TYPE in my formula field.

I would like it remain blank until an End Date value is entered.

=IF(NOT(ISBLANK([End Date]@row)), "Not Blank", "") returns the expected result.

=IF(NOT(ISBLANK([End Date]@row)), NETWORKDAYS(([Start Date]@row), ([End Date]@row)), "") returns a column formula syntax error.

Can anyone tell me what I'm doing wrong?

Antonio Figueroa

Use this

=IF(NOT(ISBLANK([End Date]@row)), NETWORKDAY([Start Date]@row, [End Date]@row), "")

Antonio Figueroa

Use this

=IF(NOT(ISBLANK([End Date]@row)), NETWORKDAY([Start Date]@row, [End Date]@row), "")

Katherine Wilgruber

Thank you, @Antonio Figueroa!

Pamela Clapp

Thank you @Antonio Figueroa