Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting Dates by Month and Day only
I have a column of dates in mm/dd/yyyy format. How can I sort them according
to month and day only. Can I use the Sort/Filter function or do I have to create formulas to do it? Thanks for your help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting Dates by Month and Day only
Hi,
Apply custom format in that column to mmm-dd Then you can sort as requested if this help please click yes, thanks "John P" wrote: I have a column of dates in mm/dd/yyyy format. How can I sort them according to month and day only. Can I use the Sort/Filter function or do I have to create formulas to do it? Thanks for your help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting Dates by Month and Day only
Hi,
You need a helper column. Say your data are in A1 down put the formula below in b1 and fill down and sort both columns on this newly created column =TEXT(A1,"mmdd") Mike "John P" wrote: I have a column of dates in mm/dd/yyyy format. How can I sort them according to month and day only. Can I use the Sort/Filter function or do I have to create formulas to do it? Thanks for your help. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting Dates by Month and Day only
Eduardo
The format affects what you see not the value so with this method the dates will still use the year in the sort Mike "Eduardo" wrote: Hi, Apply custom format in that column to mmm-dd Then you can sort as requested if this help please click yes, thanks "John P" wrote: I have a column of dates in mm/dd/yyyy format. How can I sort them according to month and day only. Can I use the Sort/Filter function or do I have to create formulas to do it? Thanks for your help. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting Dates by Month and Day only
Thanks Mike. Your solution works
"Mike H" wrote: Hi, You need a helper column. Say your data are in A1 down put the formula below in b1 and fill down and sort both columns on this newly created column =TEXT(A1,"mmdd") Mike "John P" wrote: I have a column of dates in mm/dd/yyyy format. How can I sort them according to month and day only. Can I use the Sort/Filter function or do I have to create formulas to do it? Thanks for your help. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting Dates by Month and Day only
What Mike says is correct. Thanks anyway.
"Eduardo" wrote: Hi, Apply custom format in that column to mmm-dd Then you can sort as requested if this help please click yes, thanks "John P" wrote: I have a column of dates in mm/dd/yyyy format. How can I sort them according to month and day only. Can I use the Sort/Filter function or do I have to create formulas to do it? Thanks for your help. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting Dates by Month and Day only
Glad I could help
"John P" wrote: Thanks Mike. Your solution works "Mike H" wrote: Hi, You need a helper column. Say your data are in A1 down put the formula below in b1 and fill down and sort both columns on this newly created column =TEXT(A1,"mmdd") Mike "John P" wrote: I have a column of dates in mm/dd/yyyy format. How can I sort them according to month and day only. Can I use the Sort/Filter function or do I have to create formulas to do it? Thanks for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting Dates when there are zeros in the month and/or day | Excel Discussion (Misc queries) | |||
Month sorting | Excel Discussion (Misc queries) | |||
Sorting dates by month instead of year | Excel Worksheet Functions | |||
Dates - Several Days In a month to month only | Excel Discussion (Misc queries) | |||
Sorting Month Only | Excel Discussion (Misc queries) |