software

Hello,

I have a sheet that has 4 years worth of information. For a recent
report i need to sort the data without caring about the year.

For instance i want to have all Januarys 2002-2005 in order by date,
then Feb 2002-2005 etc...

No matter what i do it sorts in order from 01/01/02-12/31/05.

Any ideas? Im stumped.

Thank you all in advance.--
joeldsmt
------------------------------------------------------------------------
joeldsmt's Profile: www.excelforum.com/member.php...oamp;userid=11889
View this thread: www.excelforum.com/showthread...hreadid=503108Put the below formula amp; copy the same till u need.

=TEXT(A1,quot;mm/ddquot;)

01/01/02 = quot;01/01quot;

the above formula will provide u as quot;01/01quot;, if u need the result as
JAN/01, then use quot;mmm/ddquot;, for January/01 then use quot;mmmm/ddquot;

Hope the above solution will help u.

----
Selvarathinam.
I will try this.

Thank you.--
joeldsmt
------------------------------------------------------------------------
joeldsmt's Profile: www.excelforum.com/member.php...oamp;userid=11889
View this thread: www.excelforum.com/showthread...hreadid=503108Hi

Assuming your dates are in column A, create a helper column alongside
your data with formula = MONTH(A1)
and copy down for the complete range.
Mark your block of data including the new helper column, and sort by the
new column.

--
Regards

Roger Govierquot;joeldsmtquot; gt; wrote
in message ...
gt;
gt; Hello,
gt;
gt; I have a sheet that has 4 years worth of information. For a recent
gt; report i need to sort the data without caring about the year.
gt;
gt; For instance i want to have all Januarys 2002-2005 in order by date,
gt; then Feb 2002-2005 etc...
gt;
gt; No matter what i do it sorts in order from 01/01/02-12/31/05.
gt;
gt; Any ideas? Im stumped.
gt;
gt; Thank you all in advance.
gt;
gt;
gt; --
gt; joeldsmt
gt; ------------------------------------------------------------------------
gt; joeldsmt's Profile:
gt; www.excelforum.com/member.php...oamp;userid=11889
gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=503108
gt;

WOW...

Worked beautifully!!!

Thanks.--
joeldsmt
------------------------------------------------------------------------
joeldsmt's Profile: www.excelforum.com/member.php...oamp;userid=11889
View this thread: www.excelforum.com/showthread...hreadid=503108