Return text after calculating quarter dates

ilwiny

Hi - I want to return a value of "Q1-25 based upon a date. I have a separate sheet with 47 rows going out for 3 fiscal years. Fiscal year starting November 1st.

From other posts I've read (Love this Community), I have learned how to calculate the Quarter but it's not calculating the year or returning the value.

This is the formula I'm using and it's returning a "1" for 12/1/24.

=INDEX({Fiscal Year Range 1}, MATCH(MONTH([End Date]@row), {Fiscal Year Range 2}, 0), MATCH(YEAR([End Date]@row), {Fiscal Year Range 4}, 0))

Any suggestions?

Thank you in advance

Paul Newcome

Try this instead:

="Q" + IF(OR(MONTH([End Date]@row) >= 11, MONTH([End Date]@row) = 1), "1", IF(MONTH([End Date]@row)<= 4, "2", IF(MONTH([ENd Date]@row)<= 7, "3", "4"))) + "-" + RIGHT(YEAR([ENd DAte]@row) + IF(MONTH([ENd Date]@row)>= 11, 1, 0), 2)

The above should work for any date and does not require a separate table.

Paul Newcome

Try this instead:

="Q" + IF(OR(MONTH([End Date]@row) >= 11, MONTH([End Date]@row) = 1), "1", IF(MONTH([End Date]@row)<= 4, "2", IF(MONTH([ENd Date]@row)<= 7, "3", "4"))) + "-" + RIGHT(YEAR([ENd DAte]@row) + IF(MONTH([ENd Date]@row)>= 11, 1, 0), 2)

The above should work for any date and does not require a separate table.