Sort by month, ignore year

  • Thread starter Thread starter Karen Scott
  • Start date Start date
K

Karen Scott

I have a big spreadsheet that has dates ranging from
01/01/95 all the way to 12/31/06. What I need it to do
is sort by month only, and ignore the year. So I would
have a list of all in January, etc, not including the
year but showing it.

Thanks,

Karen
 
Karen,

A "helper column" is just another column. Insert a blank column
next to your data, and in that column enter =MONTH(A1) and copy
down as far as you need to go. Then, sort your data using that
column as the sort order column.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Great, got it! Now, is there any way I can get it to
spell out the month, instead of a number?

Thanks!

Karen
 
Hi Karen!

And in addition to the above:

=TEXT(A1,"mmmm dd yyyy")

But for sorting other than by alpha on month name your helper for
sorting needs to be:

=TEXT(A1,"mmddyyyy")

All Januarys will be sorted first by day and then by year

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top