title: Date independent of system date in vba
body: <p>I m trying to store dates in a column and then comparing it with the dates in other column. This excel will be used by different users with different date formats on their system. I tried to format the date from yyyy-mm-dd to yyyy/mm/dd but couldn't achieve it.</p>
  
  <pre><code>Columns("AC:AC").Select
  Selection.NumberFormat = "yyyy/mm/dd"
  </code></pre>
  
  <p>How to make it independent of the system?</p>