How do I sort dates by month rather than by year?
 

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.

t,
a couple of answers here...
http://makeashorterlink.com/?O17025ADB
Jim Cone
San Francisco, USA


"terickson"
wrote in message

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.

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.