How to sort columns with date values in Excel

Sorting date columns in Excel 2016, 2013 and 2010 can be done using the option available as part of the Sort & Filter menu. Listed below are the different ways by which excel users can sort any columns with date values. Let us take the following example data set as shown in the screenshot.

image

Using Sort A to Z or Z to A

Users can quickly sort the date values either in ascending order or descending order by navigating to Editing section under Home menu then selecting Sort A to Z or Sort Z to A option.

image

Using Custom Sort

Select the Data Set that contains the column with date values. Then navigate to the Editing section and pick the Custom Sort from the Sort & Filter drop down list.

image

In the Sort dialog box, mark the check box with label as My data has headers (this is to exclude the header row in the data set) then specify the date column by which you want to sort in Sort by drop down, select Values from Sort on drop down list and choose the appropriate sort order from order drop down list. On clicking the OK button will sort the data in the specified criteria.

imageimage

In Category: Excel 2010, Office 2010

Ravi Shankar

A Software developer and blogger who is always looking to provide technical help to the wider community.

Show 1 Comment

Leave a Comment

Get your free copies of the following tech guides by joining the Digital Answers mailing list.