+ Reply to Thread
Results 1 to 2 of 2

Need Help Sorting According to Date

  1. #1
    Registered User
    Join Date
    06-05-2018
    Location
    Englewood, NJ
    MS-Off Ver
    2013
    Posts
    9

    Question Need Help Sorting According to Date

    Hi, this one might be simple but the dates are in a non-traditional-to-Excel format. I want to order the dates chronologically and also eliminate any rows containing dates from before June 4. Rows on the day of June 4 can stay.
    I've censored all the pertinent information.

    Capture.PNG

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,882

    Re: Need Help Sorting According to Date

    Hi and welcome to the forum

    Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Additionally, due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please do not take this route.

    Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

    Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Sorting by date for an irregular date format
    By needhalp in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-14-2014, 04:20 PM
  2. Converting Text to Date & Sorting on Date
    By andresndor in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-10-2014, 04:48 PM
  3. Sorting by Date--Need help when sorting by 2-digit year
    By Farris_TN in forum Excel General
    Replies: 3
    Last Post: 06-20-2013, 11:20 AM
  4. Sorting by date (different date formats)
    By mr_spaceuk in forum Excel General
    Replies: 1
    Last Post: 03-18-2010, 06:48 AM
  5. sorting date's by date number
    By KevinThomas in forum Excel General
    Replies: 2
    Last Post: 01-26-2010, 12:52 PM
  6. Sorting data by date within a date range
    By 72mako in forum Excel General
    Replies: 6
    Last Post: 12-31-2009, 03:38 PM
  7. Date Sorting with key field as date and month only.
    By kvbalakumar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-13-2009, 03:02 AM
  8. 3 columns; date and two data, problem is sorting and calculating with respect to date
    By phosphorescence in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-29-2008, 04:21 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1