# Nested IF Formula

Options
✭✭

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!

• ✭✭✭✭✭✭
Options

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"))), "")

• ✭✭✭✭✭✭
Options

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

👍

• ✭✭✭✭✭✭
Options

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"))), "")

• ✭✭
Options

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

• ✭✭✭✭✭✭