Thread: Sorting Dates
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
VBA Noob VBA Noob is offline
external usenet poster
 
Posts: 1
Default Sorting Dates


You could add another column and enter this formula

=CHOOSE(TEXT(A1,"m"),12,1,2,3,4,5,6,7,8,9,10,11)

This will enter 1 for the month of Feb, 2 for the month of March and so
on.

Then sort by the new column

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=562611