Sort by Month

C

CraigH

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.
 
M

Marcelo

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:
 
Top