| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting date fields by month excluding year
I have an access report that has been dumped into Excel. One particular
column list dates by month, day, and year. I am trying to sort the column by month. The result I get includes the year. It will sort by year, then month. I have tried reformatting data, changing text to columns, and sorting with options of using months. My desired result is a column sorted by month regardless of the year. I am sure this is something that can be done, but I am stumped. Thanks for your help -- Alisa Coppock Shafer Insurance IT Coordinator |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting date fields by month excluding year
Put in a helper column and in it enter this:
=MONTH(A1) where A1 is the date that you are trying to sort. Copy as needed. HTH, Barb Reinhardt "Alisa" wrote: I have an access report that has been dumped into Excel. One particular column list dates by month, day, and year. I am trying to sort the column by month. The result I get includes the year. It will sort by year, then month. I have tried reformatting data, changing text to columns, and sorting with options of using months. My desired result is a column sorted by month regardless of the year. I am sure this is something that can be done, but I am stumped. Thanks for your help -- Alisa Coppock Shafer Insurance IT Coordinator |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting dates by month instead of year | Excel Worksheet Functions | |||
| Date plus 1 year, but begin of month | Excel Worksheet Functions | |||
| Sort month/date/year data using month and date only | Excel Discussion (Misc queries) | |||
| Using '=MIN(DATE(YEAR(A1),MONTH(A1)+{7,6},DAY(A1)*{0,1}))' | Excel Worksheet Functions | |||
| Sorting by month, disregarding the year | Excel Discussion (Misc queries) | |||
Linear Mode
