Sorting by month and year and ignoring the day

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

Guest

I often need to sort a worksheet by month first then by one or two other
columns, my problem is that excel takes the day of the month into account. Is
it possible to do this sort only by the month and year only and ignoring the
day of the month? BTW I would prefer not using a pivot table.
 
It sorts by year first, then month and finally by day, you could use 2 help
columns
assume the list starts in A2

in B2 put


=YEAR(A2)

In C2 put


=MONTH(A2)


Select both cells and copy down as long as needed

select all 3 columns and select the order you want to sort by

--


Regards,


Peo Sjoblom
 
I'd use a helper column with a formula like:

=text(a1,"mm-yyyy")
or
=text(a1,"yyyy-mm")

sort by month then year (or by year, then month???).
 

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

Back
Top