If I want to sort by month, then day, I'll use a helper column with a formula
like:

=text(a1,"mmdd")
(and drag down)

And then sort the entire range by this helper column.

Prem Soni wrote:

Hi,

I have a excel sheet of my company employees details with their date of
birth (i.e. 20-Mar-71) detail.
now i want to short all rows by employee date of birth in acceding order.
like this:
18-Jul-1982
01-Aug-1985
08-Sep-1991
22-Nov-1986

Kindly suggest me on this.....

Thanks....
PREM SONI

--

Dave Peterson