title: Excel: Sumproduct - Import date from CSV file
body: <p>I am importing a lot of data from a csv file to my xml file. But i have a problem importing a date fra the csv file. I use sumproduct to retrieve the date since i need 3 things to be true before returning a date. </p>
  
  <pre><code>=SUMPRODUCT(
       (maler.csv!$B$4:$B$500=Data!$B$3)*
       (maler.csv!$F$4:$F$500=Data!$A$4)*
       (maler.csv!$H$4:$H$500=1);
        maler.csv!$I$4:$I$500)
  </code></pre>
  
  <p>But instead of returning 03-02-2011 (danish date format) it returns 00-01-00.</p>
  
  <p>I have tried formating cells to date, but it doenst help me. </p>
  
  <p>Does anyone have a good idear ???</p>
  
  <p>btw - i am using excel 2003 US</p>
  
  <p>Regards - Kim</p>