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

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.

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

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
--
Gary's Student


"Ruth k." wrote:

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.