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

T

terickson

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.
 
J

Jim Cone

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


"terickson" <[email protected]>
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.
 
M

Myrna Larson

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top