Sorting Dates by Month and Day only
 

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.

Sorting Dates by Month and Day only
 

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.

Sorting Dates by Month and Day only
 

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

Sorting Dates by Month and Day only
 

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.

Sorting Dates by Month and Day only
 

Thanks Mike. Your solution works

"Mike H" wrote:

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

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.

Sorting Dates by Month and Day only
 

Glad I could help

"John P" wrote:

Thanks Mike. Your solution works

"Mike H" wrote:

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