Thread: How do I convert dates (09/15/06 or 09/20/06) to month (Sept 06)?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default How do I convert dates (09/15/06 or 09/20/06) to month (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?

Reply With QuoteReply With Quote