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


"Marcelo" wrote:

> 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:
>
> > 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