Ok I figured out how to format them so they appear in the date format, but when I sort by column F they are showing up from youngest to oldest .... which is not exactly how I want to sort.

I would like to sort by birthdate (month and day) regardless of year of birth.

So eventually I would like them to appear as follows

Name1 ...... 1/5/1994
Name2 ...... 1/7/1992
Name3 ...... 1/9/1995
Name4...... 1/11/1993
Name5 ...... 1/15/1991
Name6 ...... 1/19/1994

Right now what I have is

Name5 ...... 1/15/1991
Name2 ...... 1/7/1992
Name4...... 1/11/1993
Name1 ...... 1/5/1994
Name6 ...... 1/19/1994
Name3 ...... 1/9/1995