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

  • Thread starter Thread starter Saz
  • Start date Start 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
 
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
 
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 -
Click to expand...
 
Back
Top