Extract Date then Sort

p9j123

Active Member
Joined
Apr 15, 2014
Messages
287
Office Version
  1. 2013
Platform
  1. Windows
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.
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
Column X is text not numbers (dates). Can you sort on column L?
 
Upvote 0
I need to sort X because it is what on my pivot table.
 
Upvote 0
  • 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."
 
Upvote 0
Thanks, I did't thought it was that easy.

If you sort L your formulas in X should take care of the rest.
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,494
Messages
6,113,972
Members
448,537
Latest member
Et_Cetera

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top