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

"Daniel CHEN" wrote:

> 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
> ==================================
> "SMW820" <SMW820@discussions.microsoft.com> wrote in message
> news:018718A9-791D-4676-AE9A-DD4B032B50CB@microsoft.com...
> > 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
>
>
>