Date formatting
Posted by David Bone on July 16, 2001 7:49 AM
Hi
My exported csv file has an 'ordered date' field in a 'Wed, 11 Jul, 2001' , 'Fri, 13 Jul, 2001' etc
format.
I need to be able sort this column so that it looks like '13 Jul, Fri, 2001' or something that means I can list the column by the day of the week i.e 1-30
1 Jul, Sat, 2001
2 Jul, Sun, 2001
etc
is this possible
Posted by Dax on July 16, 2001 12:57 PM
Assuming that your data is actual dates and not text you could add another column and just use the formula =DAY(A1) or whatever cell your data is in. You could then sort by this column.
HTH,
Dax.
