ExcelBanter - Sort by Month

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Sort by Month (https://www.excelbanter.com/excel-discussion-misc-queries/131049-sort-month.html)

CraigH

Sort by Month

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.

Marcelo

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.

All times are GMT +1. The time now is 05:49 AM.