I am trying to get a weeks to go formula to return "0" if negative.

I have a formula =(Date@row - TODAY()/7) to return the weeks to go for a date column. I want to make this formula to prevent it from showing negatives when weeks to go are in the past. I've tried:

=IF(Date@row - TODAY()/7 <0, Date@row - TODAY()/7, 0) and it comes unparsable. I am thinking my dividing by 7 may be the issue? Please help!

Find more posts tagged with

Formulas

Accepted answers

All comments

Jason Duryea

Try this…

=IF((Date@row - TODAY())/7, <0, 0, (Date@row - TODAY())/7)

Kait Bankey

That comes up Incorrect Argument Set... hmm

Jason Duryea

Sorry think I added an extra comma by mistake. Try this…

=IF((Date@row - TODAY())/7 <0, 0, (Date@row - TODAY())/7)

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.