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

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?

Find more posts tagged with

Formulas

Accepted answers

Antonio Figueroa

Use this

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

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.