title: CDate to recognise Australian date format?
body: <p>I have a spreadsheet I created mid-August which has a table with one column for every day since then. The column header is the day's date. The date is displayed how I want it to be displayed: "dd/mm/yyyy"</p>
  
  <p>However, I have macro which needs to read these dates in order to perform its work. Because I am using a table, the dates seem to be held as text rather than as 5-digit numbers (when I set the header cells' format to "General", it remains with the "dd/mm/yyyy" format rather than changing to a 5-digit number. This wasn't a problem until the 1st of September, after which CDate (in the macro) began reading these dates as "mm/dd/yyyy"</p>
  
  <p>Is there any way to make CDate recognise the Australian date format rather than the American? Or failing that, make the table headers stay as dates rather than as text? I'd rather avoid having to convert the Table back to a range, as the macro is designed to use table attributes, ListColumns etc.</p>
  
  <p>UPDATE:</p>
  
  <p>I've narrowed down the problem. It isn't the date, but the ListColumn.Name property. For some reason it is re-converting my date. I'm using <code>Format()</code> to set the date format, like so:</p>
  
  <pre><code>CreateHistoryColumn.Name = Format(headerDate, "dd/mm/yyyy")
  
  MsgBox Day(headerDate) &amp; "/" &amp; Month(headerDate) &amp; "/" &amp; Year(headerDate)
  MsgBox Format(headerDate, "dd/mm/yyyy")
  MsgBox CreateHistoryColumn.Name
  </code></pre>
  
  <p>Where <code>CreateHistoryCol</code> is an object of class <code>ListColumn</code>. The 3 MsgBox calls display the following:</p>
  
  <blockquote>
    <p>6/9/2012
    06/09/2012
    9/06/2012</p>
  </blockquote>
  
  <p>So the <code>Format()</code> call formats the date correctly, but the call to <code>ListColumn.Name</code> serves to alter the format to "mm/dd/yyyy". </p>