Hello John,
There are some many problems with this post and the workbook, I don't know where to start. Here are some of the major issues I found.
Where is the "This Month" worksheet?
Does the "Template" worksheet belong to another workbook or did you forget to name "Sheet1" as "Template" ?
Why are you using INDIRECT so much in the formulas when most of the references I see are simply offsets?
You have a lot of merged cells which causes a lot of referencing issues for both formulas and VBA. I don't know if you can change this format but if you can you should.
The problem with the formula is the double quotes around the RC text reference has not been properly escaped in VBA.
Here is how it should appear. The corrections are marked in red font.
Bookmarks