View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John P[_2_] John P[_2_] is offline
external usenet poster
 
Posts: 29
Default Sorting Dates by Month and Day only

What Mike says is correct. Thanks anyway.

"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.