# Thread: Sorting by date. Thanks: 0 Likes: 0

1. ## Sorting by date.

Hello,

The info below is a portion of dates that I am trying to sort:

 November 6, 1954 January 8, 1958 January 17, 1959 March 29, 1963 January 2, 1965 January 29, 1965 May 20, 1966

It is one cell per date. I would like it to sort by month and day, so that all January will be in order from Jan 01 to Jan 31, regardless of year. I know I could split the month and day into one cell and the year into a separate cell, but that would be a lot of work.

Thanks for any help!!

2. ## Re: Sorting by date.

I was able to sort as requested in 2 minutes using a column that I could hide.
Excel 2010
AB
1DatesCust Date
2January 2, 1965January 2, 2015
3January 8, 1958January 8, 2015
4January 17, 1959January 17, 2015
5January 29, 1965January 29, 2015
6March 29, 1963March 29, 2015
7May 20, 1966May 20, 2015
8November 6, 1954November 6, 2015

Sheet1

Worksheet Formulas
CellFormula
B2=DATE(YEAR(NOW()),MONTH([@Dates]),DAY([@Dates]))
B3=DATE(YEAR(NOW()),MONTH([@Dates]),DAY([@Dates]))
B4=DATE(YEAR(NOW()),MONTH([@Dates]),DAY([@Dates]))
B5=DATE(YEAR(NOW()),MONTH([@Dates]),DAY([@Dates]))
B6=DATE(YEAR(NOW()),MONTH([@Dates]),DAY([@Dates]))
B7=DATE(YEAR(NOW()),MONTH([@Dates]),DAY([@Dates]))
B8=DATE(YEAR(NOW()),MONTH([@Dates]),DAY([@Dates]))

When complete, I sorted the Cust Date column oldest to newest.

3. ## Re: Sorting by date.

Have a separate column and use for example.
B1=month(A1)
and drag the formula down, then sort by column B

5. ## Re: Sorting by date.

Thank you for taking the time to do that. I will try and get it to do the same.

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•