Sort by birthdates

B

bestivo

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??
 
F

Frank Kabel

Hi
if you have entered this information as date values Excel should do
this automatically
 
C

Chip Pearson

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
 
Top