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.
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.