Am I able to sort dates by month rather than year in excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using office 2003. I need a report that sorts my employees in order by
the month they are hired. Excel always sorts by year.
 
Just an example:

If a date is in A1 and the rest of the column, then in B1 enter =MONTH(A1)
and copy down

Then sort by column B
 
You must log in or register to reply here.

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

Date Sorting in Excel 2003 1
Sorting date fields by month excluding year 1
Sorting a date by month, date and then year. 2
Sort Dates 11
Sort "mm-dd-yyyy" by year 3
Sort by date month and not year 4
Sort month/date/year data using month and date only 6
Separating dates from one column to Month, Date, Year columns 2

Back
Top