Converting Month/Date/Year data & sorting by month/date only

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

Guest

I have pulled files from a database system which tracks dates of incorporation for businesses. I need to sort these dates by month and date, but Excel is using the year as part of the sorting criteria. Is there any way (short of manually deleting the year data) to have the program sort only by month and date?
 
is the year, date and month recorded in separate columns?

Regards,
Steve

S. Washington said:
I have pulled files from a database system which tracks dates of
Click to expand...
incorporation for businesses. I need to sort these dates by month and date,
but Excel is using the year as part of the sorting criteria. Is there any
way (short of manually deleting the year data) to have the program sort only
by month and date?
 
No, unfortunately, everything is in the same column. It would have been less of a problem had that data been listed separately

----- Steven wrote: ----

is the year, date and month recorded in separate columns

Regards
Stev

S. Washington said:
I have pulled files from a database system which tracks dates o
Click to expand...
incorporation for businesses. I need to sort these dates by month and date
but Excel is using the year as part of the sorting criteria. Is there an
way (short of manually deleting the year data) to have the program sort onl
by month and date
 
Steven said:
is the year, date and month recorded in separate columns?

Regards,
Steve


incorporation for businesses. I need to sort these dates by month and date,
but Excel is using the year as part of the sorting criteria. Is there any
way (short of manually deleting the year data) to have the program sort only
by month and date?
Click to expand...

Assuming your dates are in col A; enter this in a helper column:

=MONTH(A1)*100+DAY(A1); fill down.
Now sort by the helper col.
 
Dear 2rrs

Thanks for your help. This formula worked quite well
Because there apparently were some extra spaces captured in the date fields, I can't globally change the format to mm/dd/yyyy. So, I'll still have to move the months beginning with 10, 11, & 12 manually to the bottom of the sort, but this is nothing compared to what I thought I'd have to do
Thanks again
S. Washingto

----- 2rrs wrote: ----

Steven said:
is the year, date and month recorded in separate columns
incorporation for businesses. I need to sort these dates by month and date
but Excel is using the year as part of the sorting criteria. Is there an
way (short of manually deleting the year data) to have the program sort onl
by month and date
Click to expand...

Assuming your dates are in col A; enter this in a helper column

=MONTH(A1)*100+DAY(A1); fill down
Now sort by the helper col
 
Back
Top