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 -
Click to expand...
 

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

Similar Threads

How do you sort the data by the month of the data? 3
VBA - exporting serial letters to single documents 0
How to add day to PWA 2016 date format? 0
Date Maniplation 1
Converting MM/DD/YYYY into just MM/DD and Sorting 1
Date Formats 4
date format convert 3
Publisher is filling blank lines with data 2

Top