I'm looking for a way to paste in my formula =IFERROR(IF($J2="VSL",EDATE($K2+7,1),$K2+7),IF($K2="ETA TBD","ETA TBD")) if cell L2 has no value. Below I tried to use the following code but I get a Syntax Error when I try to run it. 


For i = 1 To Cells(Rows.Count, "L").End(xlUp).Row 'Format Dates
  If Cells(i, "L2") = "" Then Cells(i, "L2") = "=IFERROR(IF($J2="VSL",EDATE($K2+7,1),$K2+7),IF($K2="ETA TBD","ETA TBD"))"
Next i
Any help would be appreciated. Thanks