Sorting dates by month instead of year
 

I am trying to sort my employee birthday list by month and then date so I can
see at a glance upcoming birthdays. However, no matter what I do I seem to be
getting the results sorted by the year, which I do not want.

Sorting dates by month instead of year
 

If the birthday date is in column B:

=text(B2,mm/dd)

Will produce results that will sort by month.

"MMangen" wrote:

I am trying to sort my employee birthday list by month and then date so I can
see at a glance upcoming birthdays. However, no matter what I do I seem to be
getting the results sorted by the year, which I do not want.

Sorting dates by month instead of year
 

I rec'd a "value" error!

"~L" wrote:

If the birthday date is in column B:

=text(B2,mm/dd)

Will produce results that will sort by month.

"MMangen" wrote:

I am trying to sort my employee birthday list by month and then date so I can
see at a glance upcoming birthdays. However, no matter what I do I seem to be
getting the results sorted by the year, which I do not want.

Sorting dates by month instead of year
 

Try:

=text(B2,"mm/dd")



MMangen wrote:

I rec'd a "value" error!

"~L" wrote:

If the birthday date is in column B:

=text(B2,mm/dd)

Will produce results that will sort by month.

"MMangen" wrote:

I am trying to sort my employee birthday list by month and then date so I can
see at a glance upcoming birthdays. However, no matter what I do I seem to be
getting the results sorted by the year, which I do not want.

--

Dave Peterson

Sorting dates by month instead of year
 

It worked with one tweak - putting the mm/dd in quotes like this "mm/dd"

"MMangen" wrote:

I rec'd a "value" error!

"~L" wrote:

If the birthday date is in column B:

=text(B2,mm/dd)

Will produce results that will sort by month.

"MMangen" wrote:

I am trying to sort my employee birthday list by month and then date so I can
see at a glance upcoming birthdays. However, no matter what I do I seem to be
getting the results sorted by the year, which I do not want.

Sorting dates by month instead of year
 

Assuming dates are in column A

In B1, enter =MONTH(A1)

Double-click on fill handle to copy down.

Select both columns and sort on column B


Gord Dibben MS Excel MVP

On Tue, 19 Dec 2006 10:13:00 -0800, MMangen
wrote:

I am trying to sort my employee birthday list by month and then date so I can
see at a glance upcoming birthdays. However, no matter what I do I seem to be
getting the results sorted by the year, which I do not want.