I need help sorting some dates into month order. The information has been
exported from another system into an Excel spreadsheet. At present the data
is in dd/mm/yy format. I want to sort the information by month. The data
sort function will only sort it by day at present. How can I change the
format so that I can sort by month?

Insert a new column adjacent to your dates. In the new column use the formula

=month(cell with date)

Copy the formula down for all the dates, then sort on the new column.
That will put all the January dates together, regardless of the year, then
the February dates, regardless of the year, etc.


"Katherine" wrote:

I need help sorting some dates into month order. The information has been
exported from another system into an Excel spreadsheet. At present the data
is in dd/mm/yy format. I want to sort the information by month. The data
sort function will only sort it by day at present. How can I change the
format so that I can sort by month?