Thread: Sort by Month
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default Sort by Month

Hy Craig

try to use an auxiliar collumn with =month(a2) and use it to sort your tabke

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



"CraigH" escreveu:

Does anyone have a way to sort a series of dates in the "2/16/2007" format by
month? Of course, Excel wants to sort by year by default. Any thoughts?

Thanks,
Craig.