DOB short in acceding order

[Prem Soni]

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

 

[Mike H]

Hi,

At the risk of pointing out the obvious why not select them and then

Data|Sort select the column and ascending and sort

Mike

 

[David Biddulph]

It depends whether the content of your cells is text, or numbers in Excel
date format.
If the former, you'd be better chaging it to the latter, then the sort will
be easy.

 

[Prem Soni]

Hi Mike,

Thanks for responding.
I have done the same but it shorting year wise i want to short in that
column in Month and then day wise. Kindly suggest me.

Thanks,
PREM SONI

 

[Mike H]

Hi,

2 helper columns

Column b = Month(a1)
Column c =Day(a1)

Drag both columns down

Select all 3 columns then sort on Column B ascending and column C ascending

Columns B&C can be hidden

Mike

 

[Dave Peterson]

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.