Extract Date then Sort

[p9j123]

I have about 100K of records on column L is delivery date.

Column X contains the coverage date and I am using the following formula.

=TEXT(L6-WEEKDAY(L6,2)+1,"mmm-dd")&" - " & TEXT(L6-WEEKDAY(L6,2)+7,"mmm-dd")

it works perfectly...

So if L6 is 2/25/2015 then X6 will then become Feb-23 - Mar - 01.

Now here is my problem, when I sort Column X it sort alphabetically instead of based on date.

Is there a way to sort it by date instead of alphabetical?

Need you help please.

 

[JoeMo]

Column X is text not numbers (dates). Can you sort on column L?

 

[p9j123]

I need to sort X because it is what on my pivot table.

 

[JoeMo]

I need to sort X because it is what on my pivot table.

If you sort L your formulas in X should take care of the rest.

 

[Trustee]

ADVERTISEMENT

• Hi there,
• Please follow the following steeps:
• Select the cell range you want to sort. ...
• Select the Data tab on the Ribbon, then click the Sort command.
• The Sort dialog box will appear. ...
• Decide the sorting order (either ascending or descending)
• Once you're satisfied with your selection, click OK.
• The cell range will be sorted by the selected column.

"If you want to talk live, I'm part of an experiment where we are trying out free, instant chat sessions between a problem submitter and an excel expert like me. Feel free to try it! Or you can continue here, that's fine too."

 

[p9j123]

Thanks, I did't thought it was that easy.

If you sort L your formulas in X should take care of the rest.

 

[JoeMo]

Thanks, I did't thought it was that easy.

You are welcome - thanks for the reply.