Gary''s Student

Posts: n/a

Insert a helper column near the column of dates. Say you inserted in column
B. Enter =Month(A1) in the helper cell (if the date is in A1). Then copy
down.

Finally sort by the helper column.
Have a good day
--
Gary's Student

" wrote:

How can I sort dates by the month instead of the year?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sorting Dates	allmad	Excel Worksheet Functions	5	August 30th 05 03:38 PM
Sorting Dates in Days of the Week	Eagle784	Excel Discussion (Misc queries)	3	August 19th 05 05:31 PM
Sorting dates	Heather	Excel Worksheet Functions	1	June 23rd 05 02:55 AM
Question on sorting dates	Excel heavy user	Excel Discussion (Misc queries)	3	January 21st 05 05:12 PM
Sorting dates	Herb	Excel Worksheet Functions	3	October 30th 04 01:22 AM

All times are GMT +1. The time now is 06:50 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us