Each variable is a column that holds dates. I am trying to incorporate additional days onto the referenced date, as you can see with the "+15". It is giving me an error because I believe my syntax is off. What can I do to make it use Variable9 + 15 days, in the equation?
Thank you.
![]()
.FormulaR1C1 = "=IF(AND(RC" & variable9 & " > RC" & variable10 & ", RC" & variable4 & " > RC" & variable9 & "+15" & ", TRUE, FALSE)"
Bookmarks