How do we Sort dates in Excel?
 

I have a columns with dates in Excel 2003 and I want to sort them by Year,
but it does not seem to be happening. Am I missing something?

Thanks,

How do we Sort dates in Excel?
 

As long as they are numeric dates, it should be fine. They are not text
dates by chance?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Marilyn" wrote in message
...
I have a columns with dates in Excel 2003 and I want to sort them by Year,
but it does not seem to be happening. Am I missing something?

Thanks,

How do we Sort dates in Excel?
 

You could use a helper column with =YEAR(A1) copied down and do the primary
sort on that column.

Vaya con Dios,
Chuck, CABGx3



"Marilyn" wrote:

I have a columns with dates in Excel 2003 and I want to sort them by Year,
but it does not seem to be happening. Am I missing something?

Thanks,

How do we Sort dates in Excel?
 

No, they are not set to Text.

Thanks,

"Bob Phillips" wrote:

As long as they are numeric dates, it should be fine. They are not text
dates by chance?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Marilyn" wrote in message
...
I have a columns with dates in Excel 2003 and I want to sort them by Year,
but it does not seem to be happening. Am I missing something?

Thanks,

How do we Sort dates in Excel?
 

That sounds great, but I dont want that helper column showing since it will
not make sense.

"CLR" wrote:

You could use a helper column with =YEAR(A1) copied down and do the primary
sort on that column.

Vaya con Dios,
Chuck, CABGx3



"Marilyn" wrote:

I have a columns with dates in Excel 2003 and I want to sort them by Year,
but it does not seem to be happening. Am I missing something?

Thanks,

How do we Sort dates in Excel?
 

Delete it after you are done sorting. Regardless Excel sorts dates by year,
then month and finally day. What do you get if you use

=ISNUMBER(A1)

where A1 is a date that won't sort by year




--
Regards,

Peo Sjoblom



"Marilyn" wrote in message
...
That sounds great, but I dont want that helper column showing since it
will
not make sense.

"CLR" wrote:

You could use a helper column with =YEAR(A1) copied down and do the
primary
sort on that column.

Vaya con Dios,
Chuck, CABGx3



"Marilyn" wrote:

I have a columns with dates in Excel 2003 and I want to sort them by
Year,
but it does not seem to be happening. Am I missing something?

Thanks,

How do we Sort dates in Excel?
 

Just because they are not formatted to Text does not mean they aren't text.

Try DataText to ColumnsNextNextColumn Data FormatDate.

Select a format and see what happens.


Gord Dibben MS Excel MVP

On Tue, 15 May 2007 10:16:01 -0700, Marilyn
wrote:

No, they are not set to Text.

Thanks,

"Bob Phillips" wrote:

As long as they are numeric dates, it should be fine. They are not text
dates by chance?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Marilyn" wrote in message
...
I have a columns with dates in Excel 2003 and I want to sort them by Year,
but it does not seem to be happening. Am I missing something?

Thanks,