Sorting dates

H

Herb

I want to sort dates by month and day while ignoring the year. Is there a
way to do that? Thanks. -Herb Mann

7/1/2005
9/1/2003
12/15/2004
 
P

Peo Sjoblom

Only by using a help column and sort by that column

=MONTH(A2)

assuming your data starts in A2, copy down and sort

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
F

Frank Kabel

Hi
in a helper column enter the formula
=TEXT(A1,"MMDD")
and sort with this helper column
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top