Odd DATEDIF Result

[ziggle]

<p>I was wondering if any of you have seen this sort of result from DATEDIF. I am using this function to determine the age in years, months, and days of various items. </p>
<table>
<tr><td> </td><td>A</td><td>B</td><td>C</td></tr>
<tr><td>1</td><td>Start Date</td><td>31-Jul-17</td><td></td></tr>
<tr><td>2</td><td>End Date</td><td>01-Mar-19</td><td></td></tr>
<tr><td>3</td><td>Years<td>1</td><td>=DATEDIF(B1,B2,"y")</td></tr>
<tr><td>4</td><td>Months</td><td>7</td><td>=DATEDIF(B1,B2,"ym")</td></tr>
<tr><td>5</td><td>Days</td><td>-2</td><td>=DATEDIF(B1,B2,"md")</td></tr>
</table>
<p>Any help would be appreciated.</p>

 

[CharlesChuckieCharles]

There are Known errors when using "MD"

Check out this article https://support.office.com/en-us/article/DATEDIF-function-25dba1a4-2812-480b-84dd-8b32a451b35c

 

[ziggle]

There are Known errors when using "MD"

Check out this article https://support.office.com/en-us/article/DATEDIF-function-25dba1a4-2812-480b-84dd-8b32a451b35c

Perfect response! Thanks for the help.

mark