How do you sort the data by the month of the date?
 

Hi, The file has date formate as MM/DD/YYYY and I want to keep it
that
way. Is there anyway the file can be sorted by only MM? I am trying
to
sort by Jan, Feb, March...... November, December together.

Thanks,
Saz

How do you sort the data by the month of the date?
 

Using a helper column is one way. With your data in A1 down put this in B1
and drag down

=MONTH(A1)

Select columns A&B and sort by column B.

Mike

"Saz" wrote:

Hi, The file has date formate as MM/DD/YYYY and I want to keep it
that
way. Is there anyway the file can be sorted by only MM? I am trying
to
sort by Jan, Feb, March...... November, December together.

Thanks,
Saz

How do you sort the data by the month of the date?
 

Thank you Mike.... =)

On Aug 15, 8:04 am, Mike H wrote:
Using a helper column is one way. With your data in A1 down put this in B1
and drag down

=MONTH(A1)

Select columns A&B and sort by column B.

Mike



"Saz" wrote:
Hi, The file has date formate as MM/DD/YYYY and I want to keep it
that
way. Is there anyway the file can be sorted by only MM? I am trying
to
sort by Jan, Feb, March...... November, December together.

Thanks,
Saz- Hide quoted text -

- Show quoted text -

How do you sort the data by the month of the date?
 

Another option is to use this add-in
http://www.rondebruin.nl/easyfilter.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Saz" wrote in message ups.com...
Hi, The file has date formate as MM/DD/YYYY and I want to keep it
that
way. Is there anyway the file can be sorted by only MM? I am trying
to
sort by Jan, Feb, March...... November, December together.

Thanks,
Saz