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.