How can I sort dates by the month instead of the year?
G Gary''s Student Oct 6, 2005 #2 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
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
