+ Reply to Thread
Results 1 to 2 of 2

Sorting Dates from Oldest to Newest with the format YYYY-MM-DD

  1. #1
    Forum Contributor
    Join Date
    08-10-2017
    Location
    Lansing, Michigan
    MS-Off Ver
    2016
    Posts
    140

    Sorting Dates from Oldest to Newest with the format YYYY-MM-DD

    I'm importing data with the date format as stated above. I have thousands of entries to work with and I'm having a hard time figuring out how to sort it when the date format is given to me this way. Is there any way to either sort it from oldest to newest as is or moving the year to the end and then sorting from oldest to newest as normal? Thanks in advance.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Sorting Dates from Oldest to Newest with the format YYYY-MM-DD

    If the format you showed is a text string then sorting it as text will automatically give you a sort by date. It won't offer "oldest/newest" because it is not a date, but you can still sort it as text.

    If you need to convert to a date value that's a slightly different question.
    Last edited by 6StringJazzer; 01-27-2020 at 12:32 PM.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. Unable to sort dates by oldest to newest
    By probuddha in forum Excel General
    Replies: 8
    Last Post: 06-25-2016, 08:27 AM
  2. [SOLVED] Dates seem formatted correctly, but will not sort newest to oldest.
    By MelindaCapri in forum Excel General
    Replies: 6
    Last Post: 02-11-2015, 02:34 PM
  3. How to change this code to sort dates from the oldest to the newest
    By bazofio in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-29-2014, 05:24 PM
  4. Filter not working when sheet's protected
    By andyzz in forum Excel General
    Replies: 2
    Last Post: 07-22-2014, 10:51 PM
  5. [SOLVED] Sort dates in column from oldest to newest...
    By ILoveYouExcel in forum Excel General
    Replies: 2
    Last Post: 06-11-2014, 02:11 PM
  6. [SOLVED] vba to sort columns according to dates in header from oldest to newest.
    By rocksan in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-25-2012, 12:57 AM
  7. sorting a selected range by date, oldest to newest
    By zed commander in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-19-2012, 12:40 PM

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