Sorting by Dates

[Dale Spencer]

I have a column of various dates of employment from 1/01/1980 to 12/20/05 and need to sort them by the month. Ie. All January, Feb. March employees no matter what year they were employeed. How do I format the data or change the sort function to achieve this? Thanks Dale

 

[Pekkavee]

Put in B1

=MONTH(A1)

then copy down and sort by B-column.

Pekka