Question by  Andrea33 (29)

How do you sort by dates in excel?

I need to sort dates in excel.


Answer by  john11 (617)

You can treat the dates just like regular numbers. Highlight the grouping, right click on the highlighted items, and pick sort.


Answer by  Quual (161)

The standard excel sort function works just fine when sorting dates. For example we have the following data column A B 1 01/03/2010 item1 row 2 01/07/2010 item2 3 01/04/2010 item2 Highlight cells A1 to B3. Under the data menu select sort In the first 'sort by' box select Column A Click Ok


Answer by  Rajamal (121)

If so the easiest way to convert them to proper dates is to : Select the dates (assuming a single column) and go data>text to columns > next> next and specify and import date format of date on the third screen and specify dmy from the drop down, then click finish.

Reply by PickwellFarms (0):
This worked perfectly - very many thanks. pf - uk  add a comment

Answer by  anbu (5968)

Either change to the formates of your dates to YY/MM/DD and then sort then change back or set up a mule column.


Answer by  DreamScaper (354)

Highlight the group of cells that contain the date and all the information you want tied to it, right click, go to sort, and custom sort. Sort by the columns or rows that have the dates you are wanting to sort. Select a secondary sort if wanted, otherwise it will sort by date.


Answer by  technogeek (6640)

Every date, when used in excel, has been assigned a number that the program recognizes them by. It's a simple sort, because the program cannot mistake dates, no matter which format you use. Just highlight your data, go to 'data - sort', and choose which column the dates are in.


Answer by  Kit (558)

If you're using 2007 or 2010 Microsoft Office, select the entire range of cells to sort. Click Home tab, under Editing group, click Sort & Filter button. On the menu, Click Custom Sort... make sure that "My data has headers" check box, is checked. Under the Sort by: list box, select the Date field or column you want to use.


Answer by  worker63 (55)

When you enter the dates into the spread sheet you have to format the cells according to the date format you follow. Then select the datas you want to sort. On the tool bar you have the alphabet A followed by a Up arrow or down arrow symbol by selecting it you can sort ascending or descending


Answer by  saveriorocca (71)

Select all the data that you require to be sorted. Then go to the "Data" menu and select "Sort... ". In the "sort by" drop down, select the column of dates and then choose "Ascending" to sort so that January is first or select "Descending" to get December first. Then press OK and the data will be sorted.


Answer by  murali680 (559)

If we want to sort by date in excel, format should be in the following stage such as DD/MM/YY. Otherwise use mule column, we can short the data in excel.


Answer by  tamarawilhite (17883)

Highlight the column that contains the dates, or select the date range by highlighting the row of cells. Select "Data" from the tool bar, then "Sort". Now you can select the sort criteria as "ascending" or "Descending". You can also choose whether or not the first row is to be worted by whether or not it is a header row.

You have 50 words left!