Sort by date columns

[Serdarrk]

Hello,

In addition there is a file with 2 sheets. My purpose that sort by date from B1 columns to end in Sayfa1 and Sayfa2. I mean they must sort from 02.01.2007 to 31.12.2007 in every pages. Can you help me please? Also every date has additional character like -1 . I want to clean them but its not much important. First aim sort by date

https://www.dropbox.com/s/7jef7hm8rucdg58/01.02.2007-1.xls?dl=0

 

[mole999]

they will sort if they are real dates, as a number, otherwise you will need to do something that turns text into the right format

 

[Serdarrk]

They were names of sheets and these dates copy and paste from sheets what can I do now?

 

[steve the fish]

To sort by those into date order you are going to have to convert them to true dates. I dont know your local date format but if that were my machine this would work:

=0+SUBSTITUTE(LEFT(A1,FIND("-",A1&"-")-1),".","/")

Then you could sort by that instead.

 

[Serdarrk]

How can I run it?

 

[steve the fish]

You dont run it. Its a formula to convert your 'dates' to true dates. Only true dates can be sorted into date order.

 

[kvsrinivasamurthy]

Follow this procedure.

Inset two blank row number 3 & 4. That is Row 2 & 3 & 4 are blank rows.
In B2 Insert formula then drag across upto last column (IK2)

=DATEVALUE(LEFT(SUBSTITUTE(B1,".","/"),10))

Select B2:IK2 --> Copy

Select B4 --> Paste Special --> Values --> OK

Select tab DATA --> Sort --> Options

In Sort Options Select --> Sort Left to Right -->OK

In Sort By Select ROW 4

Sort On select Values

Order select A to Z --> OK

This completes sorting horizontally.

 

[Serdarrk]

O

 

[kvsrinivasamurthy]

Sorry i had forgotten
Range B2:IK2 should be formatted for date.

 

[Serdarrk]

Thank you for interest too. But I couldnt succes because (B1,".","/") part of formulation make bug?