Formula

I need assistance with a formula. I need to track the number of remaining business days until a project "Due Date," but once a "Completion Date" has been entered, I want that number of days to stop counting so that I can see how many days the project was over due.

This is what I have so far:

=IF(Status@row = "Complete", [Due Date]@row - [Completion Date]@row, [Due Date]@row - TODAY())

Find more posts tagged with

Accepted answers

All comments

Marvin Daniels

You will need another column - Completion Date. The new formula will test that column for a date, if there a date, then it will calculate using Completion Date, not Due Date. Something like this:

=IF(ISDATE([Completion Date]@row), NETWORKDAYS([Completion Date]@row]@row, TODAY()), NETWORKDAYS([Due Date]@row, TODAY()))

chawkins

So I entered this formula:

=IF(ISDATE([Completion Date]@row), NETWORKDAY([Completion Date]@row, [Due Date]@row), NETWORKDAY(TODAY(), [Due Date]@row))

Due Date: 8/24/22

Completion Date: 8/24/22

And my answer is "1"

I have played with the dates and you cannot get the "Remaining Days" to equal zero.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.