Conditional formula - if a date is less than 30 days from today

I'm trying to create a conditional formula to flag if less than 30 days from today. I create a separate column to calculate but I am getting an error on the formula.

=IF(AND([Event Date] > TODAY(), [Event Date] <= TODAY() + 30), "Less than 30 days from today", "More than 30 days from today")

Help?

Find more posts tagged with

Accepted answers

Carson Penticuff

Try this:

=IF(ISDATE([Event Date]@row), IF(AND([Event Date]@row > TODAY(), [Event Date]@row <= TODAY(30)), "Less than 30 days from today", "More than 30 days from today"), "")

All comments

Carson Penticuff

=IF(AND([Event Date]@row > TODAY(), [Event Date]@row <= TODAY(30)), "Less than 30 days from today", "More than 30 days from today")

Connie Cochran

Thank you so much! H

How do I add if it blank to leave the cell blank??

Carson Penticuff

Try this:

=IF(ISDATE([Event Date]@row), IF(AND([Event Date]@row > TODAY(), [Event Date]@row <= TODAY(30)), "Less than 30 days from today", "More than 30 days from today"), "")

Connie Cochran

Thank you!

Connie Cochran

You were so incredably helpful with this. I have an additional ask... if instead of TODAY i wanted it to look at the "Created" date instead, how would I write that? I tried the following but getting an error

=IF(ISDATE([Event Date]@row), IF(AND([Event Date]@row > [Created]@row (), [Event Date]@row <= [Created]@row(30)), "Less than 30 days from today", "More than 30 days from today"), "")

Connie Cochran

Nevermind, I got it :)

=IF(ISDATE([Event Date]@row), IF(AND([Event Date]@row > [Created]@row, [Event Date]@row <= [Created]@row + 30), "Less than 30 days from today", "More than 30 days from today"), "")

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.