title: How to show text when date is ended in excel
body: <p>i have a question
  i'm trying to show a text when Some DATE is over.
  i used this code to show the remaining date:</p>
  
  <pre><code>    =DATEDIF($J$1,B6,"Y") &amp; " years, "&amp;DATEDIF($J$1,B6,"YM") &amp; " months, "&amp;DATEDIF($J$1,B6,"MD")&amp; " days "
  </code></pre>
  
  <p>and it works fine
  now i need to show the text when ended
  i tried this code but its not working</p>
  
  <pre><code>    =if(DATEDIF($J$1,B6,"Y") &amp; " years, "&amp;DATEDIF($J$1,B6,"YM") &amp; " months, "&amp;DATEDIF($J$1,B6,"MD")&amp; " days ","Date Ended",DATEDIF($J$1,B6,"Y") &amp; " years, "&amp;DATEDIF($J$1,B6,"YM") &amp; " months, "&amp;DATEDIF($J$1,B6,"MD")&amp; " days ")
  </code></pre>
  
  <p>Does any one have another way???</p>
  
  <p>thanks in advance</p>