Record the remaining days on a project

Hello,

I have a start and end date for planned work. I'd like to see to show in a column the amount of days remaining on the project.

The issue I run into with most formulas is if the start and end are in the future, the counts are all off, and I'd like it to not record anything if the end is in the past.

I was using this formula to get the days remaining, but it doesn't take into account all the specifics I need.

=IFERROR(NETWORKDAYS([Planned Work End]1, TODAY()) * -1, "")

I'd like it to only show for ones where the Planned Work End is in the future, and show the amount of days between start and end, for projects where the start is in the future.

Find more posts tagged with

Accepted answers

L J

Try something like this:
=IF([End Date]@row < TODAY(), "In the past", IF([Start Date]@row > TODAY(), NETWORKDAYS([Start Date]@row, [End Date]@row), NETWORKDAYS(TODAY(), [End Date]@row)))

This will return:
- "In the past" for anything that has an End Date in the past (can change to 0, or blank)
- The number of working days between the start/end for anything starting in the future
- The number of days remaining for anything that has already started and the end date is in the future.

All comments

L J

PM_Reeves

Hi @Ian44

have a try with this one.

=IF(OR([% Complete]@row = 100, [End Date]@row < TODAY()), "", IF(ISERROR(NETWORKDAYS(TODAY(), [End Date}@row)), "", NETWORKDAYS(TODAY(), [End Date]@row)))

It's working for me on a test sheet, but I haven't tried on a 'live' sheet.

Ian44

@LJ

That worked like magic! Thank you so very much!

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.