filtering dates by year frist, then month and therafter day

[s1015972]

hi
please could you help.
i have a large spreadsheet with colums and rows with one colum reflecting the date which reads in this format eg 01.02.2011 (day.month.year) HOWEVER i require the colum to be filtered according to the 2011.02.01 (year.month.day). this will enable to seperate the years first.
ps:i tried the sort and filter function because the date is in 01.02.2011 (date.month.year) format, it is sorting the days frist
thanks

 

[cgcamal]

Hi s1015972,

I'm not clear enough what you need, but I think you can select the column
where date are located, then Right Click--> Cell format-->Custom and now
you can define the format you need typing yyyy.mm.dd.

If that is not the solution to your problem, please show a sample of your
input data and the desired output.

Regards

 

[JB_Scotland]

It looks like your dates are text values if they are sorting by day first. The best solution would be to insert a column in proper date format and then sort that. If your text date "2011.02.01" is in A1 make B2

=DATEVALUE(RIGHT(A1,2)&"/"&MID(A1,6,2)&"/"&LEFT(A1,4))

Format column B as date however you want it displayed.