Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2005
    Posts
    43

    Unanswered: sort by month of date

    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.
    Mos

  2. #2
    Join Date
    Jun 2002
    Location
    Houston, TX
    Posts
    116
    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
    texasalynn
    It's AWL Good!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •