I want to get min and max date and the formula is set in the sentence.
period.FormulaR1C1 = "'"+"=For the Period "+"&MIN(A7:A" + r + ")&"+" TO "+" &MAX(A7: A" + r + ")&"+"'"+"";
butt the result formula in excel cell is '=For the Period &MIN(A7:A28)& TO &MAX(A7: A28)&' and I want like that "=For the Period "&MIN(A7:A28)&" TO "&MAX(A7: A28)&""