ExcelBanter - Sorting Dates

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Sorting Dates (https://www.excelbanter.com/excel-worksheet-functions/49096-sorting-dates.html)

Sorting Dates

How can I sort dates by the month instead of the year?

Gary''s Student

Insert a helper column near the column of dates. Say you inserted in column
B. Enter =Month(A1) in the helper cell (if the date is in A1). Then copy
down.

Finally sort by the helper column.
Have a good day
--
Gary's Student

" wrote:

How can I sort dates by the month instead of the year?

All times are GMT +1. The time now is 07:12 AM.