Results 1 to 5 of 5

Thread: Sorting by date.
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Mar 2012
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Sorting by date.

    Hello,

    The info below is a portion of dates that I am trying to sort:

    November 6, 1954
    January 8, 1958
    January 17, 1959
    March 29, 1963
    January 2, 1965
    January 29, 1965
    May 20, 1966

    It is one cell per date. I would like it to sort by month and day, so that all January will be in order from Jan 01 to Jan 31, regardless of year. I know I could split the month and day into one cell and the year into a separate cell, but that would be a lot of work.

    Thanks for any help!!

  2. #2
    Board Regular CalcSux78's Avatar
    Join Date
    Oct 2013
    Location
    STL
    Posts
    1,120
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Sorting by date.

    I was able to sort as requested in 2 minutes using a column that I could hide.
    Excel 2010
    AB
    1DatesCust Date
    2January 2, 1965January 2, 2015
    3January 8, 1958January 8, 2015
    4January 17, 1959January 17, 2015
    5January 29, 1965January 29, 2015
    6March 29, 1963March 29, 2015
    7May 20, 1966May 20, 2015
    8November 6, 1954November 6, 2015

    Sheet1



    Worksheet Formulas
    CellFormula
    B2=DATE(YEAR(NOW()),MONTH([@Dates]),DAY([@Dates]))
    B3=DATE(YEAR(NOW()),MONTH([@Dates]),DAY([@Dates]))
    B4=DATE(YEAR(NOW()),MONTH([@Dates]),DAY([@Dates]))
    B5=DATE(YEAR(NOW()),MONTH([@Dates]),DAY([@Dates]))
    B6=DATE(YEAR(NOW()),MONTH([@Dates]),DAY([@Dates]))
    B7=DATE(YEAR(NOW()),MONTH([@Dates]),DAY([@Dates]))
    B8=DATE(YEAR(NOW()),MONTH([@Dates]),DAY([@Dates]))


    When complete, I sorted the Cust Date column oldest to newest.
    Cunningham's Law: "The best way to get the right answer on the Internet is not to ask a question, it's to post the wrong answer."

  3. #3
    Board Regular davesexcel's Avatar
    Join Date
    Feb 2006
    Location
    Cochrane
    Posts
    527
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Sorting by date.

    Have a separate column and use for example.
    B1=month(A1)
    and drag the formula down, then sort by column B

  4. #4
    Board Regular
    Join Date
    Jul 2014
    Location
    Memphis, TN
    Posts
    2,680
    Post Thanks / Like
    Mentioned
    11 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Sorting by date.

    Excel 2013, 2016 with PowerBI
    Knowing that it can be done is half the battle!

  5. #5
    New Member
    Join Date
    Mar 2012
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Sorting by date.

    Thank you for taking the time to do that. I will try and get it to do the same.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •