Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort Date
I've read around and no one seems to answer just the straight
question on how to sort by date in a column. I wrote a post before and was answered and confused me more than before. All I want to do is sort a series a dates in order. The dates are in the form DD/MM/YYYY. This is all in one cell. So how would I sort this in chronological order. Thank you. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort Date
Maybe, I am wrong, but dates are no peculiar problem.
Try : Range("A1:A10").Sort key1:=Range("A1"), Header:=xlNo, Order1:=xlAscending I've read around and no one seems to answer just the straight question on how to sort by date in a column. I wrote a post before and was answered and confused me more than before. All I want to do is sort a series a dates in order. The dates are in the form DD/MM/YYYY. This is all in one cell. So how would I sort this in chronological order. Thank you. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort Date
That does work as a sort but the problem is that does it as if the
date was in the order MM/DD/YYY. which would work great. My problem is my dates go in the order DD/MM/YYYY This would say that 20/4/2008 (April 20, 2008) is newer than 1/10/2008 (October, 1 2008). Do you get what I mean? That is false April comes before October but not according to the way it's set up now. On Oct 31, 2:50*pm, wrote: I've read around and no one seems to answer just the straight question on how to sort by date in a column. I wrote a post before and was answered and confused me more than before. All I want to do is sort a series a dates in order. The dates are in the form DD/MM/YYYY. This is all in one cell. So how would I sort this in chronological order. Thank you. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort Date
My local settings are DD/MM/YYYY. Which ever is the date format, the
date is fundamentally a number, so sorting should always be correct. The only point I see would be if a date is entered as M/D/Y in a D/M/Y formatted cell. Can you post a sample of your data using www.filedropper.com or else. Daniel That does work as a sort but the problem is that does it as if the date was in the order MM/DD/YYY. which would work great. My problem is my dates go in the order DD/MM/YYYY This would say that 20/4/2008 (April 20, 2008) is newer than 1/10/2008 (October, 1 2008). Do you get what I mean? That is false April comes before October but not according to the way it's set up now. On Oct 31, 2:50*pm, wrote: I've read around and no one seems to answer just the straight question on how to sort by date in a column. I wrote a post before and was answered and confused me more than before. All I want to do is sort a series a dates in order. The dates are in the form DD/MM/YYYY. This is all in one cell. So how would I sort this in chronological order. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sort date | Excel Discussion (Misc queries) | |||
sort from date, to date in list | Excel Programming | |||
the date format is not working ,sort by date doesn't work. | Excel Discussion (Misc queries) | |||
Can't sort by date | New Users to Excel | |||
Can't sort by date | New Users to Excel |