Help With Remaining Work Days Formula

All,

I'm in need of a formula that calculates remaining work days within a "start date" and an "end date".

I came up with this: =IF(ISERROR(NETWORKDAYS(TODAY(), [Start Date]@row)), "", NETWORKDAYS(TODAY(), [End Date]@row)) - which works fine as long as "today" currently falls within the "start date" and "end date".

But, I need it to account for start dates in the future. So, if my "start date" is 03/01/2024 and my "end date" is 02/29/2025, the above formula spits out "500" (but it should be 261).

Any help is appreciated.

Find more posts tagged with

Formulas

Accepted answers

Eric Law

Hello @Nicole J ,

I am a little confused about what you are trying to do. Can you give some examples? I THINK you can just use the following formula.

=IF(Today()<[Start Date]@row, NETWORKDAYS([Start Date]@row, [End Date]@row), NETWORKDAYS(Today(), [End Date]@row))

Hope this helps!

All comments

Eric Law

Hello @Nicole J ,

I am a little confused about what you are trying to do. Can you give some examples? I THINK you can just use the following formula.

=IF(Today()<[Start Date]@row, NETWORKDAYS([Start Date]@row, [End Date]@row), NETWORKDAYS(Today(), [End Date]@row))

Hope this helps!

Nicole J

Thanks, Eric. That did it.

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.