title: Error with DateDif in Excel
body: <p>i am trying to use the DateDif function in Excel and this is an error and i had no idea why.</p>
  <p>An example of the function that i want to calculate the number of years between the date is `</p>
  <blockquote>
  <p>=DATEDIF(&quot;13/4/2013&quot;,&quot;1/1/2015&quot;,&quot;Y&quot;)</p>
  <p>=DATEDIF(&quot;20/4/2013&quot;,&quot;1/1/2015&quot;,&quot;Y&quot;)</p>
  <p>=DATEDIF(&quot;29/4/2013&quot;,&quot;1/1/2015&quot;,&quot;Y&quot;)</p>
  </blockquote>
  <p>`Then the error came up was #VALUE! for all these above examples whereas if i use</p>
  <blockquote>
  <p>=DATEDIF(&quot;12/4/2013&quot;,&quot;1/1/2015&quot;,&quot;Y&quot;)</p>
  <p>=DATEDIF(&quot;5/4/2013&quot;,&quot;1/1/2015&quot;,&quot;Y&quot;)</p>
  </blockquote>
  <p>There are no errors and the function worked correctly and the result is 1</p>
  <p>Any help ? Or maybe its just a bug ?</p>