Formula to return 30,60, or 90 if Date is within 30,60,90 days

Hello,

I need a formula to return a value of 30, 60, or 90 if the due date is within 30,60,90 days of a due date. I am going to use this column to group a report to show each bucket of items due in the time frame.

I can get the formula to return the correct value if the date is within 30 days, but am not able to nest IF statements to return if the date is 60 days out, and 90 days out.

Here is the formula I used for the 30 days:

=IF(AND([End Date]@row <= TODAY(30), [End Date]@row >= TODAY()), "30", 0)

How would I nest additional criteria for 60 and 90 days?

Find more posts tagged with

Formulas

Accepted answers

Paul H

Something like this

=IF([End Date]@row < TODAY(0), "0", IF([End Date]@row < TODAY(30), "30", IF([End Date]@row < TODAY(60), "60", IF([End Date]@row < TODAY(90), "90"))))

All comments

Paul H

Something like this

=IF([End Date]@row < TODAY(0), "0", IF([End Date]@row < TODAY(30), "30", IF([End Date]@row < TODAY(60), "60", IF([End Date]@row < TODAY(90), "90"))))

Matthew_Lanterman

Ah, I see. I made mine too complicated from the start.

Thank you @Paul H

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.