sort a column by date- by month not year

  • Thread starter Thread starter Will123
  • Start date Start date
W

Will123

I have an excel sheet with columns of info and 1 column has numerous dates in
a column shown as: Jan. 1, 2002, Jan. 1, 2003, Feb. 1, 2004, Jun. 1, 2007,
Dec. 1, 2008, Jan. 1, 2004,,, etc. I am trying to sort by month... as all
January months together and all Feb. months together,,, not by year. My sort
always does it by year not month... any suggestions... Thanks.
 
Those are text dates, that's why. Convert it all at one go to real dates
using Data>Text to Cols. Select the col/range of "dates", click Data>Text to
Columns>Delimited. Uncheck all delimiters in step2. In step3, check "Date"
under Column data format, then select: MDY from the droplist. Click Finish
Success? celebrate, thump the YES below
 
One has to correct the cores first, otherwise nothing will work
With the real dates running in A2 down
In B2, copied down: =TEXT(A2,"mmm")
would etch out the months in alphas in col B. Then you could sort both cols
A and B by col B, ascending (say) to give the required results in 2 wags
 
I bet they are real dates. Otherwise, why should they sort on year?
Your advise about an extra column is correct.
 
Hai.... you can sort month wise by following process.... go to the next column type the formula =month(select from the column you want to sort)........ you will get numeric value and then you can sort... in case of any doubt get back.... bye....



Will123 wrote:

sort a column by date- by month not year
28-Dec-09

I have an excel sheet with columns of info and 1 column has numerous dates i
a column shown as: Jan. 1, 2002, Jan. 1, 2003, Feb. 1, 2004, Jun. 1, 2007
Dec. 1, 2008, Jan. 1, 2004,,, etc. I am trying to sort by month... as al
January months together and all Feb. months together,,, not by year. My sor
always does it by year not month... any suggestions... Thanks.

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Dynamic Localization / Multi-Lingual Content
http://www.eggheadcafe.com/tutorial...7e-9b2248890401/dynamic-localization--mu.aspx
 
Back
Top