sorting by date with day "ranges"

  • Thread starter Thread starter DJ
  • Start date Start date
D

DJ

Sorry if I missed something really easy. But I have two columns one
with dates "Apr 12-15" and May 2-4", etc... and the other column with
locations - Omaha - st. louis, etc....

What I want to do is sort by date and take the day range in account.
Now I know how to sort under the data pull down if I dont have the day
"range" in the same cell and everything works fine with no numbers or
just a single day(like 5-apr-2004). But I don't want to make another
column for the end date if I dont have to. I thought I could do
somthing in the custom format option like mmm-dd - dd but that only
puts the same day twice. I would like to keep all the date info to one
cell. thanks for any advise.


-dj

btw - Desired output

Date Location
Jan 3-8 St. louis
Feb 21-27 omaha
Jun 15-20 D.C.

etc.....
 
You should make another column for end date, you will never be able to sort
that
without using a couple of help columns that will parse out the real dates
since what you have is pure text.
And since you would need help columns you wouldn't save anything. As a
ground rule, always put
numeric value in distinct cells..
 
Peo Sjoblom said:
You should make another column for end date, you will never be able to sort
that
without using a couple of help columns that will parse out the real dates
since what you have is pure text.
And since you would need help columns you wouldn't save anything. As a
ground rule, always put
numeric value in distinct cells..

--

Regards,

Peo Sjoblom
Click to expand...


Arrgh!!! OK I thought so. Peo, Thanks for the help.
 
Back
Top