title: Excel If Statement finding number of days between two dates
body: <p>As an example I have three columns Target completion,  Actual completion and Entered date</p>
  
  <pre><code>Column A Target Completion 1/5/13/2013
  Column B Actual Completion 1/25/2013
  Column C Entered Date 1/2/2013
  </code></pre>
  
  <p>I need to add 30 days to Column A (Target Completion) and then compare that new date to Column B (Actual Completion) and finally show the result in days. </p>
  
  <p>Like this;</p>
  
  <pre><code>Column A Target Completion 1/5/13/2013
  Column B Actual Completion 1/25/2013
  Column C Entered Date 1/2/2013
  </code></pre>
  
  <p>Result = -10 days (30 days are added to column A then minus column B)</p>
  
  <pre><code>Column A Target Completion 3/1/13/2013
  Column B Actual Completion 5/1/2013
  Column C Entered Date 1/2/2013
  </code></pre>
  
  <p>Result = 30 days (30 days are added to column A then minus column B)</p>
  
  <p>I have been trying to get this if statement to work …but no luck!! Thank you in advance. </p>
  
  <pre><code>=if(E14="",DATEDIF(DATEVALUE("06/28/2013"),TODAY(),"d"),DATEDIF(E14,C14,"d"))
  </code></pre>