Share via

Sorting in Excel Column having data as Week Range

Anonymous
2017-09-14T07:11:33+00:00

Hi,

I have a Week Range Data as Below which has Start date of the Week and End Date, I'm Trying to Sort the Column but it doesn't get Sorted as required, Help me on this Please

01/02/17-01/08/17
01/02/17-01/08/17
01/02/17-01/08/17
02/01/16-02/07/16
02/01/16-02/07/16
02/13/17-02/19/17
02/13/17-02/19/17
03/07/16-03/13/16
03/07/16-03/13/16
03/20/17-03/26/17
03/20/17-03/26/17
05/02/16-05/08/16
05/02/16-05/08/16
08/08/16-08/14/16
08/08/16-08/14/16
09/05/16-09/11/16
09/05/16-09/11/16
10/31/16-11/06/16
10/31/16-11/06/16
Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-09-14T17:33:05+00:00

    First of all, Excel treats this DATA as text & its not NUMERIC to get sorted.

    Figure shows as if its already in MANUAL sorted order.

    Provide some sample data so that we can give some workaround & also weeks in random way.

    Suggestion:

    Use week starting date in A column

    Week ending date in B column

    And then apply filter & sort it, so that the corresponding row also gets sorted.

    After sort if you want both Starting & ending week to be in same cell.

    Then use Concatenate formula

    Was this answer helpful?

    0 comments