title: datedif formula -how to create a 0 Days result if the time between the cells is zero?
body: <p>I'm looking for one heck of a complicated formula!</p>
  <p>I'm counting the years, months, and days between two cells in Google Sheets.</p>
  <p>In the first row in the image below I'm counting the years, months, and days between column C and column D. In the second row, I'm doing the same, but I also need to add that if the result is zero days then the output/answer should just be 0 Days. How do I do that?</p>
  <p>This is the formula I've used so far to get what you see in the image.</p>
  <pre><code>=datedif($C3,$D3,&quot;y&quot;)&amp;&quot; Yr &quot;&amp;datedif($C3,$D3,&quot;ym&quot;)&amp;&quot; Mths &quot;&amp;datedif($C3,$D3,&quot;md&quot;)&amp;&quot; Days&quot;
  </code></pre>
  <p><a href="https://i.stack.imgur.com/zXUK3.png" rel="nofollow noreferrer">sample out put</a></p>