I am trying to comparing two dates using RC notation like this:
Range("Q3").Select
.ActiveCell.FormulaR1C1 = _
"=OR(AND(ISBLANK(RC[-7])=FALSE,RC[-9]=""Yes""),AND(ISBLANK(RC[-7])=FALSE,RC[-1]=TRUE), AND(RC[-5] > RC[-6],RC[-9]=""No""))"
.Selection.AutoFill Destination:=Range("Q3:Q2999"), Type:=xlFillDefault
RC[-5] and RC[-6] contain the dates I am talking about. I need to check whether the date in RC[-5] is greater than the date in RC[-6].
Am I using the correct notation? Because the result I am getting is not what I expected/correct.