Posted to microsoft.public.excel.worksheet.functions

Crackles McFarly Crackles McFarly is offline

external usenet poster

Posts: 49

Need help sorting DATES please..

I have a large amount of data, it's simply dates.
example
4/4/92
1/3/2007
5/6/1955
etc

I want to display ONLY the month and then SORT only by the month.

Basically I want to ignore the YEAR in the date and then sort.

I've tried this several ways BUT it will not sort the numbers even if
I format them.

help?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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	Murray	Excel Discussion (Misc queries)	3	July 23rd 06 08:59 PM
Sorting Dates	[email protected]	Excel Worksheet Functions	1	October 6th 05 11:19 PM
Sorting Dates	allmad	Excel Worksheet Functions	5	August 30th 05 03:38 PM
Sorting dates	Heather	Excel Worksheet Functions	1	June 23rd 05 02:55 AM
Sorting dates	Herb	Excel Worksheet Functions	3	October 30th 04 01:22 AM

All times are GMT +1. The time now is 11:41 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us