title: Conditional Excel Sum based on dates range
body: <p>I have got a spreadsheet in where dates are in column B and values are in column E.</p>
  
  <p>Dates are with the format: dd/mm/yy
  Values are with the format: XXX,XX€</p>
  
  <p>I am trying to sum cells based on dates but I can't.</p>
  
  <p>I am using the function SUMIFS like this to calculate the values from November:</p>
  
  <pre><code>=SUMIFS(E9:E1000;B9:B1000;"&gt;="DATE(2014;11;1)&amp;"&lt;="DATE(2014,11,30))
  </code></pre>
  
  <p>I am doing something wrong but I don't know what.</p>