Check a Date Range

I need help with defining a formula to evaluate a date. I have a “Date” column which contains a mm/dd/yy date. I want to evaluate that column to return “Yes” if the date is within the current month and the next 60 days.

For example:

“Date” = 07/10/22

Today’s Date = 07/22/22

Is the “Date” within the range: 07/01/22 – 09/20/22*? In this example, it would be true and return “Yes”.

*09/20/22 derived from Today+60 days

What is the easiest way to do this? Asking before I end up in a formula quagmire.

Find more posts tagged with

Sheets

Education

Formulas

Support

Community Platform

Accepted answers

Jeff Reisman

Try this:

=IF(OR(MONTH(Date@row) = MONTH(TODAY()), AND(Date@row >= TODAY(), Date@row <= TODAY(60))), "Yes")

In English: If the Date on this row is in the current month, or if the Date on this row is greater than or equal to today AND less than or equal to the date 60 days from today, set this cell to "Yes".

All comments

Hollie Green

=IF([Date]@row >= DATE(2022, 7, 1), IF([Date]@row <= [Date]@row + 60, "yes", "no"))

For some reason, it doesn't return the no if it is false but the yes does return. Will need additional assistance if you need it to return a different value when false.

Jeff Reisman

Try this:

=IF(OR(MONTH(Date@row) = MONTH(TODAY()), AND(Date@row >= TODAY(), Date@row <= TODAY(60))), "Yes")

Amanda Gilroy

Thank you @Jeff Reisman ! You save me what probably would have been an obscene amount of time. ;-) This worked perfect!

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.