convert year date to month and day only

  • Thread starter Thread starter Wiersma7
  • Start date Start date
W

Wiersma7

I need to convert a date - mmmm dd, yyyy to just mmmm dd for sorting
purposes by month and date - not year. How can I do this?
Thanks,
wiersma7
 
You can add another column and use a formula like:

=text(a1,"mmdd")

Then sort all the data by this helper column.

If you use a string of "mmmm dd", your data will sort alphabetically--not by
date (ignoring the year).
 
Thanks much! Worked like a charm.
Never thought about the alpha sort. Silly me :)
wiersma7
 
Back
Top