Dates

Emma · Jun 3, 2004

I am importing data on which includes hundreds of dates in the format 09/11/76. Problem is that I need to sort them by month (ignoring day and year). Is there any way I can do this?

David McRitchie · Jun 3, 2004

Hi Emma,
create another column and use the fill handle to copy down
=Month(A1)
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Emma said:
I am importing data on which includes hundreds of dates in the format 09/11/76. Problem is that I need to sort them by month

(ignoring day and year). Is there any way I can do this?