Discussion Locked

Sorting Excel Dates by Month

0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
How do I sort Excel by month and day if I have the date format "June 15, 1900". This would be helpful for finding all employees that started in Jan, the Feb...... Etc.

6 replies

by amberhaze

One way to do this would be to create 2 hidden temp columns. the first is a function pulling the month, the second the day of the month. You then would simply issue a sort based on these two temp columns...

There are probably more elegant ways of doing it, but the above would take about a minute to set up and be done...

by sgt_shultz

you might be looking to Sort.
Highlight all you data, pick Data (from the text menu along the top of Excel) then pick Sort. you can choose the column to sort by and the sort order (descending/ascending)

by rrbdba

I'm not having a problem sorting. I need to get all the Jan (in day order) together, followed by all the Feb ... Etc. without regard to year. When sorting I get Jan - Dec of year 01 followed by Jan thru Dec of year 02....Etc

by bschaettle

Remember that "June 15, 1900" is simply the displayed format of the underlying "date" data, unless you stored it as text (hope not).

Sorting it should be easy. On the Excel menubar, click on "Data" then "Sort" and tell it to sort using the column that contains the dates.

by rrbdba

I'm not having a problem sorting. I need to get all the Jan (in day order) together, followed by all the Feb ... Etc. without regard to year. When sorting I get Jan - Dec of year 01 followed by Jan thru Dec of year 02....Etc

This discussion is closed to new replies.