| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
|
#3
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sort dates stored as 1-Jun-05 in order of day & month | Excel Worksheet Functions | |||
| sort dates by day then month, not by year. | Excel Worksheet Functions | |||
| sort dates by month and day not year | Excel Worksheet Functions | |||
| How sort dates just by day/month and NOT year if all 3 given in ce | Excel Worksheet Functions | |||
| How to sort by day and month while ignoring year? | Excel Worksheet Functions | |||
Linear Mode
