convert year date to month and day only

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
 
D

Dave Peterson

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).
 
W

Wiersma7

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
date format convert 2
date 2
DATE 2
How to import data 3
Conditional formatting with linked value 3
Default date format for dates entered without a year 2
date varable 5

Top