Nested IF Formula

Tara_A

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!

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!

👍

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

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!

👍