title: How to find Date between two date columns in excel
body: <p>I have two tables in excel, first with columnA (date),columnB(date), and second table columnC(date),columnD(values), i want to highlight Cells from columnD(values)
  if columnC(date) is between columnA and columnB?
  What i try is with this formula:<br>
   <code>=IF(AND(A2&gt;$B$1,A2&lt;$c$1),a2, FALSE)</code><br>
  but i don't get any result?</p>
  
  <p>What i expect is this:<a href="https://i.stack.imgur.com/eSs4j.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/eSs4j.png" alt="enter image description here"></a></p>