Greetings, all:

I have a (hopefully) quick question. I have a field (column) called birthdate, which is in short date format (mm/dd/yy). If I do a sort, Excel sorts by the yy, however, I would like it to sort by the mm. That is, let's say we have four records with the following birthdates

1/1/85
3/3/72
5/1/64
1/5/65

For ascending order, Excel will sort as follows:

5/1/64
1/5/65
3/3/72
1/1/85

That is, the four records are sorted in ascending order by the year, with oldest being first. Is there any to sort via month, such that the order would be:

1/1/85
1/5/65
3/3/72
5/1/64

I realize I can do this by normalizing (having a separate column for mm, dd, and yy).

Thanks in advance.

in a separate column put in this formula
=text(a2,"MM")
copy that formula down the length of your data
then you can sort by the new column as the 1st criteria, then use the birthday column as the 2nd criteria