Sort by birthdates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need some help sorting a list of student by their birthdate. I want to
sort them so I have the youngest first and the oldest last. Has anyone had
experience with this??
 
Hi
if you have entered this information as date values Excel should do
this automatically
 
In another column, use a formula like

=TEXT(MONTH(A1),"00")&TEXT(DAY(A1),"00")

and copy this formula down as far as you need to go. Then, sort
by that column.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If B2=x, then for all values of A2, place y in C3 1
Can't change birthdate in cell 3
sorting birthdays formatted as month and day (no year involved) 8
Excel 2003 How do I determine an age of "?" using a set date as r 1
Segment and count birthdays 2
I need to sort a column by month 2
How do I sort a birthdate list by month then day regardless of ye. 1
How do I sort dates by month rather than by year? 2

Back
Top