Forum Discussion

Jim_Cross's avatar
Jim_Cross
Copper Contributor
Feb 16, 2021
Solved

Unable to sort a column of dates in Excel for Mac 2016

In my master excel spreadsheet in Excel for Mac 2016 I have rows of data each row with a date In the attached excel file I extracted the column of dates I need to sort by date earliest to latest and...
Excel on Mac
  • Rich99's avatar
    Rich99
    Feb 18, 2021

    Jim_Cross

    Hi

    Insert a column and try using this formula,=DATEVALUE(MID(A3,5,2)&"/"&LEFT(A3,3)&"/"&RIGHT(A3,4))
    Then copy and paste special so your just left with the date values, then sort using Oldest to Newest or visa versa.

     

    Example attached

     

Rich99's avatar
Rich99
Iron Contributor
Feb 18, 2021

Jim_Cross

Hi

Insert a column and try using this formula,=DATEVALUE(MID(A3,5,2)&"/"&LEFT(A3,3)&"/"&RIGHT(A3,4))
Then copy and paste special so your just left with the date values, then sort using Oldest to Newest or visa versa.

 

Example attached

 

  • Jim_Cross's avatar
    Jim_Cross
    Copper Contributor
    Feb 19, 2021

    Rich99 

     

    Many thanks

    Worked fine

    Jim

Resources