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

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

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.

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.

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.

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.

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.