Sorting Date Column

D

Dave C

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
 
M

Mike H

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top