How do I convert dates (09/15/06 or 09/20/06) to month (Sept 06)?

[Kwalityguy]

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?

 

[Gord Dibben]

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

 

[Marcelo]

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:

 

[David Biddulph]

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.