title: Compare dates in 2 column with same ID and find latest date
body: <p>I have 3 column <br>
  A = ID<br>
  B = S_Provided<br>
  C = M_Provided<br></p>
  
  <p>In column D, I would like to populate the newest/latest Date for given ID between B &amp; C</p>
  
  <p><strong>Here is Screenshot</strong><br>
  Formula I have in D2 is <code>=IF(A2=A1,D1,IF(B2&gt;C2,B2,C2))</code> <br>
  but this formula failed when <code>ID=81</code>. D should be <code>11/11/2012 4:15:00 PM</code> </p>
  
  <p><img src="https://farm9.staticflickr.com/8105/8658414922_cd193b2398_b.jpg" alt="enter image description here"></p>