Sorting a lsit by month

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting date fields by month excluding year 1
Sort by date month and not year 4
Sort "mm-dd-yyyy" by year 3
Sorting a date by month, date and then year. 2
Sorting by month and year and ignoring the day 2
Bargain 30GB for £10 a month on a 1 month contract. 4
Sort by Month 1
Sort by date but not year 4

Back
Top