Using FormulaR1C1 to input complex formula into cell

Hello again,
I need to create formulas based on the contents of the above cell.
An example:

Please Login or Register  to view this content.

The dates, however, are not going to be static. The date range must always be for eight years, but it will be eight years back from the previous month end.
I think I can figure out how to change dates around so that it's always 8 years back from the current date, but I don't know how to handle inputting variables into that formula. There are too many quotation marks.
Anyway, I'm kind of confused, any help appreciated, thanks.

Oh whoa I did not realize that i could just toss variable names into the middle of the string there. VBA lets you do all sorts of crazy things... I was doing crazy concatenation, using "" to print a ", etc.

Thanks a lot.