You can't use formatting, you need to use a help column

=MONTH(A1)

will return the month's number, assume first date is in A1, copy down as
long as needed then select both columns and sort by the help column

--

Regards,

Peo Sjoblom

"lcardwell" wrote in message
...
I would like to sort dates in a spreadsheet by month and day - not year.
How
can I change the format to avoid the year being used while sorting?