MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.