How to use the results of a concantenated cell as a formula in another cell

[u4carson]

Hello, this is likely a simple question but I am struggling.

The end result is I would like a formula to populate and calculate using a "date field" that will change based on the data I am importing. I thought I could concatenate but the result is just the concatenated formula. So I tried referencing the generated formula and it does not calculate. Please see below... ultimately, no matter how I get there, I need A6 (QUARTER) to actually calculate the formula based on the field listed in G1, in this case C6. Changing the format of A6 didn't help.

 

[Fluff]

Is the cell set to text format?
Also is "Show formulas" selected on the formula tab.

 

[u4carson]

I figured it out, I just needed to write the formula in A6 with the indirect function. =IF(INDIRECT(B1)="","","Q"&ROUNDUP(MONTH(INDIRECT(B1))/3,0)&"-"&YEAR(INDIRECT(B1)))

Thank you