|Subject:||Help needed changing date formats from m/d/y to d/m/y|
|Posted by:||Craig Thomson (email@example.com)|
|Date:||Tue, 28 Oct 2003|
I have a spreadsheet with a column of dates in the format ddd
m/d/yyyy, e.g. "Mon 9/29/2003". The data has come in as text as I have
cut and pasted it from another source.
I sort of have something working, but it only works for dates with 2
digits (i.e. from October (10th month) on and from the 10th of each
month on), e.g. "Wed 29/10/2003". The formula I have is:
Can anyone help me get this to work for all dates?
Thanks in advance.