Networkdays Formula

Tarin Horonzy

Help! I've tried a 1000 different versions and nothing has worked quite right yet!

We are counting workdays between a due date (date- due) and date of issue correction (date- corrected).

Also, I don't want to receive the #invaliddata if my date- corrected cell is blank.

I'm good with: =IFERROR(NETWORKDAYS([Date- Due]@row, [Date- Corrected]@row), "")

However, in my mind... issues corrected on the same day should return 0. And currently it returns 1.

Examples:

Date- Due/// Date- Corrected/// TAT Currently/// TAT Desired

3/3/21/// 3/4/21/// 2/// 1

3/3/21/// 3/3/21/// 1/// 0

3/8/21/// 3/2/21/// -5/// -4

Find more posts tagged with

Formulas

Accepted answers

All comments

Genevieve P.

Hi @Tarin Horonzy

The formula looks correct, however I understand that you don't want a 1 for the same-day (or 1 day). I recently worked with another member on this post, here, to develop a solution around this: https://community.smartsheet.com/discussion/comment/282023

Let me know if the formulas on that thread make sense or if you'd like more help!

Cheers,

Genevieve

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.