Date Sorting

T

tarynnl

How do i sort a column of dates by the month rather than day

E.g. when i sort a column with different dates its sorting them by day

20/11/2003
21/11/2003
22/10/2003
22/10/2003
24/11/2003

rather than by month then by day

22/10/2003
22/10/2003
20/11/2003
21/11/2003
24/11/2003

Thank
 
P

Peo Sjoblom

Use a help column

=MONTH(A2)

copy down and sort first by the help column and then on the full dates
 
T

tarynnl

Thanks that works

but it does seem to be a long way to sort dates

does anyone know of an easier way especially seen as i have to do thi
ofte
 
P

Peo Sjoblom

Why is it long? Assume that you have 2000 dates in A, if you select B and
insert a new blank column B,
then use the formula I gave you and double click the lower right corner it
will copy down the formula in a few seconds.
Select the whole table and sort it at most takes a few minutes, then delete
the help column.
Btw, you are wrong in your first assertion, excel sorts the dates first by
year, then month and finally day. So your remark that it sorts by day is
wrong..
 
Top