Feb 16 2021 12:05 PM
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 put that column in a new excel sheet so I can practice.
I am unable to figure out how to do it.
Any help would be appreciated.
Jim
Feb 16 2021 12:25 PM
Column A is formatted as Text, so Excel sees he values in column A as text, no as date.
Do the following:
Feb 17 2021 05:18 PM
Hans
I don't have some of the options you suggest on Office for Mac 2016.
Are you thinking of regular Microsoft Office?
Jim
Feb 18 2021 12:37 AM
I have Office for Windows, so I can't help you with specific details of Excel on MacOS.
Feb 18 2021 06:44 AM
SolutionHi
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
Feb 19 2021 10:29 AM
Feb 18 2021 06:44 AM
SolutionHi
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