Nested IF Formula

I would like the IF statement to return a specified value if based upon date ranges. For example, if a date falls within a range:

09/01/23 - 11/30/23 should return the value "Q1"

12/01/23 - 02/29/24 should return the value "Q2"

03/01/24 - 05/31/24 should return the value "Q3"

06/01/24 - 08/31/24 should return the value "Q4"

This is what I have so far: =IF([End Date]@row >= DATE(2023, 9, 1), "Q1")

Any assistance you can provide would be greatly appreciated!

Find more posts tagged with

Formulas

Conditional Formatting

Accepted answers

Carson Penticuff

See if this works for you. This ignores the days and year and simply matches the quarter based on the month.

=IFERROR(IF(AND(MONTH([End Date]@row) >= 9, MONTH([End Date]@row) <= 11), "Q1", IF(OR(MONTH([End Date]@row) = 12, MONTH([End Date]@row) <= 2), "Q2", IF(AND(MONTH([End Date]@row) >= 3, MONTH([End Date]@row) <= 5), "Q3", "Q4"))), "")

Carson Penticuff

Awesome, I'm glad you were able to learn something from it!

👍

All comments

Carson Penticuff

See if this works for you. This ignores the days and year and simply matches the quarter based on the month.

Tara_A

@Carson Penticuff Thank you so much! That works perfectly!! I appreciate you so much. I learned something new.😊

Carson Penticuff

Awesome, I'm glad you were able to learn something from it!

👍

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.