Eduardo

The format affects what you see not the value so with this method the dates
will still use the year in the sort

Mike

"Eduardo" wrote:

Hi,
Apply custom format in that column to

mmm-dd

Then you can sort as requested

if this help please click yes, thanks

"John P" wrote:

I have a column of dates in mm/dd/yyyy format. How can I sort them according
to month and day only. Can I use the Sort/Filter function or do I have to
create formulas to do it? Thanks for your help.