Return text after calculating quarter dates

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

Best Answer