How to return a MAX Value of "0" if Remaining # of Weeks is < 0

Hello Amazing Community,

I'm trying to create a formula to Remaining Number of Weeks on a project.

Start Date = 5/30/23

End Date = 6/15/23

Formula for Remaining # of Weeks (from today) =NETDAYS(TODAY(), [End Date]@row) / 7 = -2.9

**Problem is when End Date is in the past, and TODAY keeps changing, in which case, Remaining # of Weeks becomes a bigger negative number. How do I edit this formula where the MAX returned value is =0 since technically you can't have a remaining # of weeks to be a negative number?

Hope that makes sense. Thank you

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

You could use the MAX function.

=MAX(current formula, 0)

=MAX(NETDAYS(TODAY(), [End Date]@row) / 7, 0)

All comments

Carson Penticuff

=IF([End Date]@row > TODAY(), NETDAYS(TODAY(), [End Date]@row) / 7, 0)

Paul Newcome

You could use the MAX function.

=MAX(current formula, 0)

=MAX(NETDAYS(TODAY(), [End Date]@row) / 7, 0)

Christine Cao

@Paul Newcome @Carson Penticuff Thank you both. This worked.

Paul Newcome

Happy to help. 👍️

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.