Function for Working Days Remaining

HI Smartsheet Help Team,

I use the following function to calculate the working days remaining.

=IF(ISERROR(NETWORKDAYS(TODAY(), [End Date]@row)), "", NETWORKDAYS(TODAY(), [End Date]@row))

However, I want to modify the function so that when it reaches the end date, it will become 0 because right now it becomes a negative figure.

Do you know how to change this function, please?

Thanks!

Find more posts tagged with

Formulas

Accepted answers

All comments

Shanky Paul

Hi,

Try the below formula:

=IFERROR(IF(NETWORKDAYS(TODAY(), [End Date]@row) >= 0, NETWORKDAYS(TODAY(), [End Date]@row), 0), "")

Thank you!

AAL

Thank you Paul, however, can you briefly explain this function to me, please?

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.