Re: Sort Dates by Month and Day, Not Year

Tech-Archive recommends: Speed Up your PC by fixing your registry

I don't open files.

Remember that this formula only works on dates--not text. If it's not working,
I bet your "dates" aren't dates--just plain old text.



Al Franz wrote:

Thanks Dave that helps. Still haven't gotten my desired result, but if you
have a minute maybe can take a look at the following....

http://netmation.com/dateprob.xls

Can see the formula I am currently using and see if there is a way to get
the forumula to give me the desired results. The cells in red are the
desired results the formula is not working for.

"Dave Peterson" <petersod@xxxxxxxxxxxxxxxx> wrote in message
news:49577B5A.1646BC4@xxxxxxxxxxxxxxxxxxx
I'd use a formula like this in a helper column:

=text(a1,"mmdd")

Then sort the data by that helper column.

Al Franz wrote:

Is there a trick to sort a date column by Month and Day, and not have it
sort the list by year as first sort. Without breaking up the data into
multiple columns.

--

Dave Peterson

--

Dave Peterson
.

Relevant Pages

  • Re: Sort key
    ... can sort it manually, recorded sort looks the same as written code, and ... Dave Peterson wrote: ... Susan wrote: ...
    (microsoft.public.excel.programming)
  • Re: VB runtime errors...
    ... Thanks, Dave! ... Dim Numrows As Integer ... "Dave Peterson" wrote: ... > That giant sort statement could be replaced with these 3 sort ...
    (microsoft.public.excel.misc)
  • Re: Sort Dates
    ... Dave I appreciate the tips but this isn't happening. ... "Dave Peterson" wrote: ... stumped and never seemed to have problems in prior versions of Excel. ... As I added dates I could always sort from lowest to highest ...
    (microsoft.public.excel.misc)
  • Re: Sumproduct ... Maybe?
    ... "Dave Peterson" wrote: ... have another person working this file & I am thinking a "sort" probably ... Cols A, B, C of TabSheet1 with values of Cols A, B, C in Tabsheet2 & then ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Sorting is Incomplete
    ... I'm not defending Dave who has posted the same answer about 3 times to OP. ... Gord Dibben MS Excel MVP ... He should change the dates to real dates and then the sort will ... "Dave Peterson" wrote: ...
    (microsoft.public.excel.misc)