Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Date Column
I have a column of (event) dates where the usual entry is a single date,
however, sometimes an event runs over two days so I would need to enter two dates within a cell - see example below. 01/06/08 01/07/08 - 02/07/08 I've formatted the column as date but the two day events always sort to the top/bottom of the column depending on the ascending/decending sort. Is it possible to get the two day cells to sort based on the first date (in the above example 01/07/08) ? If this is not possible I guess the only way is to make separate columns for the start/end date and then sort on the start date column. Thanks for any advice. Dave |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Date Column
Hi,
You need a helper column. With your data laid out like this Column A Date 01/06/08 01/07/08 - 02/07/08 If necessary insert and new column to the right and then in B2 enter the formula =LEFT(A2,8)*1 Drag this down to the same length as your data then select all of your data and sort on this new column. The newly inserted column can be hidden if you want. Mike "Dave C" wrote: I have a column of (event) dates where the usual entry is a single date, however, sometimes an event runs over two days so I would need to enter two dates within a cell - see example below. 01/06/08 01/07/08 - 02/07/08 I've formatted the column as date but the two day events always sort to the top/bottom of the column depending on the ascending/decending sort. Is it possible to get the two day cells to sort based on the first date (in the above example 01/07/08) ? If this is not possible I guess the only way is to make separate columns for the start/end date and then sort on the start date column. Thanks for any advice. Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting a date by month, date and then year. | Excel Discussion (Misc queries) | |||
column not sorting correctly by date | Excel Discussion (Misc queries) | |||
SORTING A COLUMN BY DATE | Excel Discussion (Misc queries) | |||
Sorting a Pivot Table Column that is not the first column... | Excel Worksheet Functions | |||
Right column doesn't change when sorting left column. | Excel Discussion (Misc queries) |