Sort month/date/year data using month and date only

[SMW820]

Hi,

I am attempting to sort a list of companies that are formatted in our
database system by month/date/year (mm/dd/yyyy). I want them to sort by
month and date only, however Excel 2000 recognizes the year as a criteria.

How do I get the program to ignore the year information for these 4,000+
entries?

Thanks so much.
SMW820

 

[Daniel CHEN]

An indirect way:
Insert two extra columns - one for month using MONTH function and another
for day using DAY function.
Then sort by month and day.

--
Best regards,
---
Yongjun CHEN
==================================
- - - - www.XLDataSoft.com - - - -
Free Excel/VBA Tool & Training Material
==================================

 

[Marcelo]

Hi,

you could use an auxiliar column with =month(a1)&day(a1) copy it down and
sort by this column

HTH
Regards from Brazil
Marcelo

"SMW820" escreveu:

 

[SMW820]

Hi Daniel:

Thank you for your solution. At first I did not understand. After reading
the second response from Marcelo, I got it! And it worked!

Thanks again.
SMW820

 

[SMW820]

Hi Marcelo:

Thank you for your response. I had received another similar solution prior
to yours, and did not understand. I gained clarity after reading your
answer. And it worked!

Thanks so much.
SMW820

 

[daddylonglegs]

Hi,

you could use an auxiliar column with =month(a1)&day(a1) copy it down
and
sort by this column

HTH
Regards from Brazil
Marcelo

I think you'd have a problem with this approach. 11th January and 1st
november would both become 111.

For a one column approach try

=DATE(0,MONTH(A1),DAY(A1))

 

[SMW820]

Hi "daddylonglegs",

Yes, I can see where this might become an issue and luckily I did not have
any of these dates in the system. However, I will also keep this version of
the recommended solutions on hand for future reference.

Thanks very much for your help.
SMW820