Help with Birth Dates

  • Thread starter Thread starter Sillysamiam
  • Start date Start date
S

Sillysamiam

I have a list of names and birthdates. The dates are as follows. 19840822.
Year Day Month.

How can I sort this so it is listed in

month day year order??
 
Hi Sillysamiam!

To get dates use:

=DATE(A1/10000,MID(A1,5,2),RIGHT(A1,2))

To sort use Data > Text to columns
Then sort based on those three columns in Month > Day > Year order.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top