Network Day giving negative number for the same day

Nishith

We have this formula to give us how many days are left for the Purchase order

=-NETWORKDAY([Due Date: PO Ready]1150, TODAY())

But whenever I have today selected I get a negative -1 as Day Remaining

Same happens when I select day after tommorow just gives me 2 as Days remaining

How can I fix this? When the days are more or difference is more then the formula works as intended

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

Try this:

=IF([Due Date: PO Ready]@row = TODAY(), 1, IF([Due Date: PO Ready]@row = TODAY(1), 2, NETWORKDAY(TODAY(), [Due Date: PO Ready]@row)))

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.