sorting of date of birth

  • Thread starter Thread starter jv
  • Start date Start date
J

jv

I need to have our staff listing sorted the date of birth
in a month & date order.
ex.
column: A (wrong) B (right)
22-May-44 5-Feb-52
23-Feb-47 23-Feb-47
30-Oct-49 22-May-44
23-Jul-51 23-Jul-51
21-Oct-51 14-Aug-52
5-Feb-52 15-Oct-52
14-Aug-52 21-Oct-51
15-Oct-52 30-Oct-49
6-Dec-52 6-Dec-52

From the above example, column a was the result of my
sorting, i need to have the result sorted in a way
displayed in column b.

For your kind assistance.

Thank you.

jv
 
Add this formula to another column (row 1) and copy the
formula down. Then select both columns and sort ascending
on this formula column:

=MONTH(A1)&"-"&DAY(A1)

HTH
Jason
Atlanta, GA
 
jv,

You need to use a helper column, with the formula

=DATE(2003,MONTH(A1),DAY(A1))

Assumes your dates start in cell A1. Format for Month and day only,
leaving out the year, copy down to match your data, and then sort
based on the helper column.

HTH,
Bernie
MS Excel MVP
 
You would need 2 help columns, if the dob starts in A2 , in B2 put

=MONTH(A2)

in C2

=DAY(A2)

select B2 and C2 and double click lower right corner of C2 to copy down the
formula

then select the full table and sort by b and c and a ascending
 
Jason,

I tried but it does not work here, sorting has no effect
either, is it possible to follow the format in column b
which is what im trying to achieve, wherein the year will
also appear (dd-mmm-yy).

jv
 
Jason,

Im sorry If it is only now that i reply, coz im in the
middle east right now.

I tried again the formula that you gave me and it works
perfectly, maybe im too tired lastnite that i made some
mistakes.

Thank you so much.

jv
 
Back
Top