title: Conditional formatting is not working for dates comparison
body: <p>Trying to implement conditional formatting (row colouring) for two columns - one string and one date condition (I do this in two approaches, but none of them works):</p>
  
  <pre><code>&gt; Dim y As Date
  &gt;     y = DateAdd("d", 30, Date) Debug.Print y Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _
  &gt;      "=OR(AND($H2=""1. Qualify"",$P2=""Google"", Days(now(),$Z2)&lt;30  ),AND($H2=""1. Qualify"",$P2=""AWS"", $Z2 &lt;
  &gt; DateValue(y)))"
  &gt;          Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
  &gt;     With Selection.FormatConditions(1).Interior
  &gt;         .PatternColorIndex = xlAutomatic
  &gt;         .Color = vbRed
  &gt;         .TintAndShade = 0
  &gt;     End With
  &gt;     Selection.FormatConditions(1).StopIfTrue = False
  </code></pre>
  
  <p>Any idea of the reason why?</p>