sorting by date
 

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: http://www.excelforum.com/member.php...o&userid=30379
View this thread: http://www.excelforum.com/showthread...hreadid=500385

sorting by date
 

Insert 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

"debradebra" wrote
in message ...

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:
http://www.excelforum.com/member.php...o&userid=30379
View this thread: http://www.excelforum.com/showthread...hreadid=500385

sorting by date
 

Add another column and use a formula like:

=text(a2,"mmddyyyy")
and drag down
and then sort by that column.



debradebra wrote:

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: http://www.excelforum.com/member.php...o&userid=30379
View this thread: http://www.excelforum.com/showthread...hreadid=500385

--

Dave Peterson

sorting by date
 

thank you both very much. I got it to work with your help!:)


--
debradebra
------------------------------------------------------------------------
debradebra's Profile: http://www.excelforum.com/member.php...o&userid=30379
View this thread: http://www.excelforum.com/showthread...hreadid=500385