Sorting by date.

PACKERS

New Member
Joined
Mar 9, 2012
Messages
6
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

<colgroup><col></colgroup><tbody>
</tbody>

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!!
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
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
Cell Formulas
RangeFormula
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.
 
Upvote 0
Have a separate column and use for example.
B1=month(A1)
and drag the formula down, then sort by column B
 
Upvote 0

Forum statistics

Threads
1,213,561
Messages
6,114,316
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top