How do you sort the data by the month of the data?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Saz - 15 Aug 2007 13:34 GMT

Hi, The file has date formate as MM/DD/YYYY and I want to keep it that
way. Is there anyway the file can be sorted by only MM? I am trying to
sort by Jan, Feb, March...... November, December together.

Thanks,
Saz

Reply to this Message

squenson - 15 Aug 2007 19:15 GMT

You should create a new column, let's say G, with the formula G2: =MONTH(A2),
where A is the column containing the date. Then you can sort according to
this column. But if you have dates for more than one year, all the entries
for January 2006 and January 2007 will be sorted together. Use instead
G2=YEAR(A2)*100+MONTH(A2) to avoid this situation.

Stephane.

Reply to this Message

Philip Reece-Heal - 13 Sep 2007 16:41 GMT

Assuming the date in your sheet is numerical and not text, then a possible
solution is to create a column next to your date column (and assuming your
date column is A) in the new column enter the formula =MONTH(A1) which will
give you the month (numbered 1 to 12). Copy formula down the rows you want
and sort on that column.

You could then hide the new column or delete it altogether.

Hope that is of help

Philip[

> Hi, The file has date formate as MM/DD/YYYY and I want to keep it that
> way. Is there anyway the file can be sorted by only MM? I am trying to
> sort by Jan, Feb, March...... November, December together.
>
> Thanks,
> Saz

Reply to this Message

gls858 - 13 Sep 2007 19:46 GMT

> Assuming the date in your sheet is numerical and not text, then a
> possible solution is to create a column next to your date column (and
[quoted text clipped - 14 lines]
>> Thanks,
>> Saz

Not very elegant, but when I need to do this I just break the date into
3 columns month,day,year by using text to columns and format it as text.

gls858

Reply to this Message

Rate this thread: