Sorting Dates by Month and Day only

[John P]

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.

 

[Eduardo]

Hi,
Apply custom format in that column to

mmm-dd

Then you can sort as requested

if this help please click yes, thanks

 

[Mike H]

Hi,

You need a helper column. Say your data are in A1 down put the formula below
in b1 and fill down and sort both columns on this newly created column

=TEXT(A1,"mmdd")

Mike

 

[Mike H]

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

 

[John P]

Thanks Mike. Your solution works

Hi,

You need a helper column. Say your data are in A1 down put the formula below
in b1 and fill down and sort both columns on this newly created column

=TEXT(A1,"mmdd")

Mike

 

[John P]

What Mike says is correct. Thanks anyway.

Hi,
Apply custom format in that column to

mmm-dd

Then you can sort as requested

if this help please click yes, thanks

 

[Mike H]

Glad I could help

Thanks Mike. Your solution works