title: Days between two date in vba
body: <p>I have two dates. I want to count number of days between.</p>
  
  <pre><code>date_today = Format(Now(), "dd/mm/yyyy")
  
  test_date = Format(wsM.Range("M10").Value, "dd/mm/yyyy")
  
  result= DateDiff("D", date_today, test_date)
  </code></pre>
  
  <p>I see in debug:</p>
  
  <p><a href="https://i.stack.imgur.com/dsMKJ.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/dsMKJ.jpg" alt="debug"></a></p>
  
  <p>The result is wrong. How can I fix this?</p>