Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sorting dates by month
I have a sheet with a column of dates in the standard format mm/dd/yy
A simple A to Z sort - sorts on the year. Could anyone tell me how to sort it by the month instead Thankyou |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
sorting dates by month
Hi Kauflton!
Add a helper column with the following as the basis formula: =TEXT(A1,"mmddyyyy") -- Regards Norman Harker MVP (Excel) Sydney, Australia Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
sorting dates by month
Hi
I would add a helper column. Insert the following in the first row =MONTH(A1) copy this down for all rows and then sort by this helper column HTH Frank kauflton wrote: I have a sheet with a column of dates in the standard format mm/dd/yy. A simple A to Z sort - sorts on the year. Could anyone tell me how to sort it by the month instead? Thankyou |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
sorting dates by month
You need a helper column with a formula, such as
=MONTH(A1) and sort both columns with the helper column as the key. If you wish to include year, you could try =TEXT(A1,"yyyymm") -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "kauflton" wrote in message ... I have a sheet with a column of dates in the standard format mm/dd/yy. A simple A to Z sort - sorts on the year. Could anyone tell me how to sort it by the month instead? Thankyou |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting Dates by Month and Day only | Excel Worksheet Functions | |||
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) |