Transpose Quarters from Calendar Year to Fiscal Year

Hello
Perhaps a Lookup function would do as you require:

=LOOKUP(MONTH(A1),{1,4;4,1;7,2;10,3})

The date here being in cell A1.

Hope this helps.
DBY