title: Validating specific date format in Excel
body: <p>I need to verify whether the dates in my Excel table are in the correct format, which is <code>yyyy/mm/dd</code>, so any other formats like <code>mm/dd/yyyy</code> would be incorrect.</p>
  
  <p>I am using this formula:</p>
  
  <pre><code>=IF(NOT(ISERROR(DATEVALUE(TEXT(W2,"yyyy/mm/dd")))),"valid date","invalid date"
  </code></pre>
  
  <p>While the formula did pick up cells that did not contain a date, it failed to pick up cells that had dates in the wrong format like <code>mm/dd/yyyy</code>.  What am I missing from my formula?  Please help.  </p>
  
  <p>Thank you in advance.</p>
  
  <p>Kev</p>