Sorting Dates by Month and Day only

  • Thread starter Thread starter John P
  • Start date Start date
J

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.
 
Hi,
Apply custom format in that column to

mmm-dd

Then you can sort as requested

if this help please click yes, thanks
 
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
 
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
 
Thanks Mike. Your solution works

Mike H said:
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
Click to expand...
 
What Mike says is correct. Thanks anyway.

Eduardo said:
Hi,
Apply custom format in that column to

mmm-dd

Then you can sort as requested

if this help please click yes, thanks
Click to expand...
 
Back
Top