title: How to do an if statement that will return the word ”New” in column A if it beats the criteria in column F?
body: <pre><code>Sub test
      Dim BR As Long
      BR = Range(“B” &amp; Rows.Count).End(xlUp).Row
      Range(“A4”).Formula =“=if(F4&gt;datevalue(“3/29/2019”),”New”,””)”
      Range(“A4”).Copy
      Range(“A4:A” &amp; BR).PasteSpecial xlPasteAll
  End sub
  </code></pre>
  
  <p>I realize that the formula will not work because it ends the statement with the first parentheses but I can’t figure out how to do this formula in vba. If you could help that would be greatly appreciated.</p>