You can use a "helper" column containing this formula, and sort on that helper
column. The gormula assumes the original date is in A1:

=MONTH(A1)*100+DAY(A1)




On Fri, 23 Sep 2005 10:18:01 -0700, terickson
wrote:

I pulled a birthdates query out of our data base and when I sort the
worksheet it sorts by the year. I am a beginner with querys so I do not know
how to change the format of the cells so that I can sort by month and day
instead.