title: Google Sheets issue comparing dates
body: <p>I'm having issues with a date comparison producing an incorrect result and cannot identify why.</p>
  <p>I'm using this for a more complex formula but identified this logic as being the reason the other formula is not working correctly. In this very simple formula: IF(start date &lt; new date,&quot;T&quot;,&quot;F&quot;), all of the results should be &quot;T&quot; but are showing up as &quot;F&quot;. I verified all date values are dates with ISDATE() and the strange thing is using DATEDIF correctly calculates the date difference, so I'm having trouble figuring out why the IF comparison isn't working.</p>
  <p>Please see screenshots below. Any help is appreciated, thanks.</p>
  <p><a href="https://i.stack.imgur.com/gYNTJ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/gYNTJ.png" alt="enter image description here" /></a></p>
  <p><a href="https://i.stack.imgur.com/7sugq.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/7sugq.png" alt="enter image description here" /></a></p>
  <p><a href="https://i.stack.imgur.com/1yn9f.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1yn9f.png" alt="enter image description here" /></a></p>
  <p><a href="https://i.stack.imgur.com/sxfiO.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/sxfiO.png" alt="enter image description here" /></a></p>