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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Format Problem. 2
How to enter a date in DD-MM-YYYY format 2
Conditional formatting with linked value 3
Getting MM-DD HH:MM out of Julian date 4
date format convert 2
Counting dates & time. 2
date 2
DATE 2

Back
Top