title: If statement returning #NAME error
body: <p>Basically I have two different columns; column G and H</p>
  
  <p>I would like to make it so that if the Column H is greater than today's date Coloumn G equals "G" for good and if Column H is less than today's date Column G will equal "R" for not on track</p>
  
  <pre><code>=IF(H84&lt;TODAY,"R","G")
  </code></pre>
  
  <p>My return is #NAME?</p>
  
  <p><img src="https://i.stack.imgur.com/SrK8Q.png" alt="enter image description here"></p>