title: SharePoint calculated conditional formula to return zero if column is zero
body: <p>I have calculated date formula for Projected NVSMR column:</p>
  
  <pre><code>=DATE(YEAR([Last NVMSR])+[3yr], MONTH([Last NVMSR]), DAY([Last NVMSR]))
  </code></pre>
  
  <p>Which is great. But, I also want it to return zero if the 3yr column equals zero.  I have tried  different <code>DATEDIFF</code>'s and just <code>IF</code> formulas and SharePoint returns <code>#NUM</code> for all members listed or Syntax error.  </p>
  
  <p>I am the awards monitor and only certain individuals are allowed a three year award.  If they are not allowed a three year award I want to enter "0" and have "0" return in the Projected NVMSR column "0".</p>