Formula has stopped working in Excel 2007

Worksheets("REPORTS").Range("S22").Formula = "=+'18 hole scores'!RC" & DateColumn . I have had this formula for 4 years and it worked fine. It puts a vaue like C27 into cell S22. I have not made a...