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

[Saz]

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

 

[Guest]

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]

Thank you Mike.... =)

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






- Show quoted text -

 

[Ron de Bruin]

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