Network Days count off (as well as showing blank for no entry)

Hello (searched and couldn't find), Thank you in advance for support.

Typical "Start Date" and "Actual End Date" columns. Having an issue with days in between not lining up correctly.

3/16/22 through 3/16/22 should equal "0" however shows "1"

3/16/22 through 3/17/22 shows 1

Every time i try to manipulate the number it doesn't align to one another.

Currently Using:

=IFERROR(NETWORKDAYS([Start Date]@row, [Actual End Date]@row) - IF(AND([Start Date]@row <> "", [Start Date]@row = [Actual End Date]@row), -1) - 1, "")

Screen Shot 2022-10-20 at 12.44.22 PM.png

Screen Shot 2022-10-20 at 12.45.05 PM.png

PS: I am also using blanks for no entry in both fields (which works)

Thank you

Find more posts tagged with

Accepted answers

All comments

kelele20

I had a similar issue. i resolved it with:

=IF([Date Delivered]@row >= [Due Date]@row, NETWORKDAYS([Due Date]@row, [Date Delivered]@row) - 1, NETWORKDAYS([Due Date]@row, [Date Delivered]@row))

Due date - Start Date

Date delivered - End date

Morris R

Hello - Thank you,

=IF([Actual End Date]@row >= [Start Date]@row, NETWORKDAYS([Start Date]@row, [Actual End Date]@row) - 1, NETWORKDAYS([Start Date]@row, [Actual End Date]@row))

Worked for for some days but not for others which is odd.

Also the BLANK days showing "invalid data type"

3/16/22 through 3/16/22 = zero (great)

3/16/22 through 3/17/22 = 1 (great)

3/16/22 through 3/18/22 = 2 (great)

3/16/22 through 3/19/22 = 2 (not sure why this didn't change

3/16/22 through 3/20/22 = 2 (not sure why this didn't change)

3/16/22 through 3/21/22 = 2 (not sure why this didn't change)

3/16/22 through 3/22/22 = 4 (not sure why this didn't change)

3/16/22 through 3/23/22 = 5 (not sure why this didn't change)

Screen Shot 2022-10-21 at 8.14.12 AM.png

Thank you for reviewing - maybe I missed something prior to morning coffee. :)

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.