software

hi all...I'm a little new to this and was hoping someone could help me.
I'm doing a data entry job with a long list of birthdates. The client
wants the list sorted by birthdate, but not by year. For instance she
wants all January 1 birthdays to be sorted together by year and then to
sort January 2 birthdays and so on. So I want to be able to sort first
by month, then by day, then by year. So far I have only been able to
get the dates to sort first by year and then by month and day. As I've
already entered more than 700 birthdates, I really hope there is a way
to do this. Any one know?--
debradebra
------------------------------------------------------------------------
debradebra's Profile: www.excelforum.com/member.php...oamp;userid=30379
View this thread: www.excelforum.com/showthread...hreadid=500385Insert two new columns. If your dates are in Column A, then B1 would be
=Month(A1). Fill down. C1 would be =Day(A1). Fill down.

Sort on those columns. Of course they don't have to be Column B and C, they
could be K and L as well.

--
Kind regards,

Niek Otten

quot;debradebraquot; gt; wrote
in message ...
gt;
gt; hi all...I'm a little new to this and was hoping someone could help me.
gt; I'm doing a data entry job with a long list of birthdates. The client
gt; wants the list sorted by birthdate, but not by year. For instance she
gt; wants all January 1 birthdays to be sorted together by year and then to
gt; sort January 2 birthdays and so on. So I want to be able to sort first
gt; by month, then by day, then by year. So far I have only been able to
gt; get the dates to sort first by year and then by month and day. As I've
gt; already entered more than 700 birthdates, I really hope there is a way
gt; to do this. Any one know?
gt;
gt;
gt; --
gt; debradebra
gt; ------------------------------------------------------------------------
gt; debradebra's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30379
gt; View this thread: www.excelforum.com/showthread...hreadid=500385
gt;
Add another column and use a formula like:

=text(a2,quot;mmddyyyyquot;)
and drag down
and then sort by that column.
debradebra wrote:
gt;
gt; hi all...I'm a little new to this and was hoping someone could help me.
gt; I'm doing a data entry job with a long list of birthdates. The client
gt; wants the list sorted by birthdate, but not by year. For instance she
gt; wants all January 1 birthdays to be sorted together by year and then to
gt; sort January 2 birthdays and so on. So I want to be able to sort first
gt; by month, then by day, then by year. So far I have only been able to
gt; get the dates to sort first by year and then by month and day. As I've
gt; already entered more than 700 birthdates, I really hope there is a way
gt; to do this. Any one know?
gt;
gt; --
gt; debradebra
gt; ------------------------------------------------------------------------
gt; debradebra's Profile: www.excelforum.com/member.php...oamp;userid=30379
gt; View this thread: www.excelforum.com/showthread...hreadid=500385

--

Dave Peterson


thank you both very much. I got it to work with your help!--
debradebra
------------------------------------------------------------------------
debradebra's Profile: www.excelforum.com/member.php...oamp;userid=30379
View this thread: www.excelforum.com/showthread...hreadid=500385