I have a table with data entered by date. I want to sort the data by month.
If I merely format the date to show month-year, the data is still only sorted
by date. How do I convert a date entered as 09/15/06 to a month displayed as
Sept 06?

Use a helper column to get the month only.

Assume dates are in column A

In B1 enter =MONTH(A1) to return the month number.

Drag/copy down or double-click on the B1 fill handle.

Sort on column B which will have month numbers.


Gord Dibben MS Excel MVP

On Thu, 28 Sep 2006 13:07:01 -0700, Kwalityguy
wrote:

I have a table with data entered by date. I want to sort the data by month.
If I merely format the date to show month-year, the data is still only sorted
by date. How do I convert a date entered as 09/15/06 to a month displayed as
Sept 06?

Hi,

did you think use an auxiliar column with =month(a2) to sort it?

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Kwalityguy" escreveu:

I have a table with data entered by date. I want to sort the data by month.
If I merely format the date to show month-year, the data is still only sorted
by date. How do I convert a date entered as 09/15/06 to a month displayed as
Sept 06?

"Kwalityguy" wrote in message
...
I have a table with data entered by date. I want to sort the data by
month.
If I merely format the date to show month-year, the data is still only
sorted
by date. How do I convert a date entered as 09/15/06 to a month displayed
as
Sept 06?

Data/ Text to columns/ Delimited, & at the end choose Date, & MDY from the
drop down box.
--
David Biddulph