| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I sort dates by months?
Hi
I have a lot of birthday dates that I want to group into months. But, I am having difficulty to sort them by months. It keeps sorting by years! The birthday format is dd/mm/yyyy. Can anyone help? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I sort dates by months?
helper column with =month(a1) and use that as primary
-- Don Guillett SalesAid Software "David" wrote in message ... Hi I have a lot of birthday dates that I want to group into months. But, I am having difficulty to sort them by months. It keeps sorting by years! The birthday format is dd/mm/yyyy. Can anyone help? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I sort dates by months?
You will need to put the month(s) in a separate "helper" column and sort on
this column. If dates are in column A then in your "helper" column put: =MONTH(A2) and copy down. Sort on this column. "David" wrote: Hi I have a lot of birthday dates that I want to group into months. But, I am having difficulty to sort them by months. It keeps sorting by years! The birthday format is dd/mm/yyyy. Can anyone help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding months to dates should account for 28-30-31 day months | Excel Worksheet Functions | |||
| how do i sort dates by months and not years? | New Users to Excel | |||
| SUMIF for Dates / Months ? | Excel Worksheet Functions | |||
| months between 2 dates!!! | Excel Discussion (Misc queries) | |||
| Need More Help on Dates to Months | Excel Worksheet Functions | |||
Hybrid Mode
