Need to convert text

[GyleMc]

=“O”&(MATCH((EOMONTH(A20,0)-C20+1),A4:A15)+3)&":X"&(MATCH((EOMONTH(A20,0)-C20+1),A4:A15)+3)

This formula returns “O7:X7”. I need to use in the formula =RANK(F20,O7:X7). What do I need to do to get my formula to return O7:X7 (without quotes) so it will work in the RANK formula?

[Villeroy]

INDIRECT(“O7:X7”) converts the address into a reference.

OFFSET(A3;MATCH(EOMONTH(A20;0);A4:A15);14;1;10) returns the same reference.
From A3 MATCH(…) rows down, 14 columns to the right, resized to 1 row, 10 columns.