Sorting a lsit by month

M

mike_vr

Hey, so I have a list of data, which i need to sort by month (but just the
month, no day or year). there has got to be an easy way of doing this that
i'm just not thinking about. thanks.
 
D

Dave Peterson

I'd use a helper column:

=month(a1)
and drag down
(where A1 contained the date)

Then sort by that.

If I wanted to sort by mmddyyyy, I'd use a helper formula like:
=text(a1,"mmddyyyy")
This would sort by month, then if there were ties, by day, then finally by year.
 
Top