title: Read date value from import Excel in PHP
body: <p>I've problem with read date value from import value (Excel) to mysql database. i've code as below :</p>
  
  <pre><code>$dataexcel[$i-3]['date_edit'] = date('m/d/Y', strtotime(trim($data['cells'][$i][25])));
  </code></pre>
  
  <p>i tried use <code>strtotime</code>to define value from excel, but i've problem to save it into database, if my value in excel with excel date format is <code>1/1/2018</code> (it read as 1 Jan 2018, English time format), after i used my code above, it saved become <code>1970-01-01</code> it means 1 Jan 1970.</p>
  
  <p>in another example, 
  i tried another input with date <code>2/1/2018</code>, it saved into database as <code>2018-02-02</code>.</p>
  
  <p>from my samples above, in first there missmatch problem with year, then and in the 2nd sample missmatch problem come from date,</p>
  
  <p>so how to declare date to solve my problem, if i want to save date format with simple way?
  if there any advice , please, thanks...</p>