Thread: How do I convert dates (09/15/06 or 09/20/06) to month (Sept 06)?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo Marcelo is offline
external usenet poster
  
Posts: 1,047
Default How do I convert dates (09/15/06 or 09/20/06) to month (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?
Reply With QuoteReply With Quote