Does anyone know how to return the date format of dates stored as text?
I have a column of dates delimited by commas which I split into individual strings. I then want to determine the date format for each string.
Examples of desired results:
If cell contains "301009" ---------------- then return dmy
If cell contains "12/05/09" -------------- then return dd/mm/yy
If cell contains "12/05/2009" ------------ then return dd/mm/yyyy
If cell contains "05/21/09" -------------- then return mm/dd/yy
If cell contains "Mon-10-2008" ---------- then return ddd-m-yyyy
If cell contains "12 November 2009" ----- then return dd mmmm yyyy
<TABLE id=table1 cellSpacing=0 cellPadding=2 width="50%" border=0><TBODY><TR vAlign=top><TD align=left></TD><TD align=left></TD></TR><TR vAlign=top><TD align=left>Thanks for you assistance
Michael
</TD><TD align=left></TD></TR><TR vAlign=top><TD align=left></TD><TD align=left></TD></TR><TR vAlign=top><TD align=left></TD><TD align=left></TD></TR></TBODY></TABLE>
I have a column of dates delimited by commas which I split into individual strings. I then want to determine the date format for each string.
Examples of desired results:
If cell contains "301009" ---------------- then return dmy
If cell contains "12/05/09" -------------- then return dd/mm/yy
If cell contains "12/05/2009" ------------ then return dd/mm/yyyy
If cell contains "05/21/09" -------------- then return mm/dd/yy
If cell contains "Mon-10-2008" ---------- then return ddd-m-yyyy
If cell contains "12 November 2009" ----- then return dd mmmm yyyy
<TABLE id=table1 cellSpacing=0 cellPadding=2 width="50%" border=0><TBODY><TR vAlign=top><TD align=left></TD><TD align=left></TD></TR><TR vAlign=top><TD align=left>Thanks for you assistance
Michael
</TD><TD align=left></TD></TR><TR vAlign=top><TD align=left></TD><TD align=left></TD></TR><TR vAlign=top><TD align=left></TD><TD align=left></TD></TR></TBODY></TABLE>