VBA -- Compare two dates and map "Yes" or " No" -- Getting Syntax Error at FormulaR1C1

[Vinod Krishna.C]

Dear all,

I'm trying to compare two dates from two different column values. If they are same, I need to map as "Yes" and otherwise "No".

I've written a Formula and getting an error at the following line in my code:

ActiveCell.FormulaR1C1 = "=IF(RC[" & M_SD_Col - M_NS_Col & "]" & "=" & "RC[" & M_TD_Col - M_NS_Col & "]" & ",'Yes',No')"

Goal is to calculate the same using formula.

Ex:

	A	B	C
Emp No	Start Date	Term Date	No Show?
1	3/6/2017	3/6/2017
2	11/28/2016

In the end, value under "No Show?" column should be:

=IF(A2=B2),"Yes","No"

PFA for the sheet with error at the code mentioned above.

Request your help in fixing this line of code

Thanks,
Vinod Krishna