sort date

shilpi2
shilpi2 used Ask the Experts™
on
Hi Experts,

I want to sort a column of dates in descending order. However, I am unable to do so. PFA the excel sheet.

Thanks

Shilpi
Book1.xls
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2010
Commented:
shilpi2,

It's because your "dates" are actually text.  This formula will convert them to actual date values, which you can then sort:

=DATE(RIGHT(B2,4),MID(B2,4,2),LEFT(B2,2))

Patrick

Author

Commented:
I tried. Still does not sort.:-(
Book1.xls
Top Expert 2010

Commented:
Your first sort field needs to be Column C.

I just did this:

1) Selected the populated range in B:C

2) Did a sort based on Col C, descending, no header row

It sorted exactly as expected.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial