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

S

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
 
M

Mike H

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
 
S

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 -
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top