Filter dates by the day
 

Excel 2003.

I wish to send my client's birthday cards and am attempting to filter thier
DOB's so that they are ordered from the first of the month to the last.

I'm having a problem as excel only filter the whole date oldest to newest
and doesn't take into account the actual day. EG: - with the list below
excel has filtered using the year.

What I want is for the day to be filtered regardless of the year - so that i
can send out the cards on a daily basis.

Is this possibile and can anyone tell me how?

Thanks
Chris

13/09/1940
19/09/1940
25/09/1940
27/09/1940
27/09/1940
13/09/1941
14/09/1941
16/09/1941
17/09/1941
29/09/1941
29/09/1941
16/09/1942
16/09/1942
17/09/1942
19/09/1942
26/09/1942
13/09/1943
16/09/1943
22/09/1943
26/09/1943
27/09/1943
13/09/1944

Filter dates by the day
 

Hi Chris,

Dates in column A

Column B would have the formula =MONTH(A1)
Column C would have the formula = DAY(A1)

then you can just sort by column B ascending, column C ascending to get them
in the order you need

HTH
--
Allllen


"Chris AM" wrote:

Excel 2003.

I wish to send my client's birthday cards and am attempting to filter thier
DOB's so that they are ordered from the first of the month to the last.

I'm having a problem as excel only filter the whole date oldest to newest
and doesn't take into account the actual day. EG: - with the list below
excel has filtered using the year.

What I want is for the day to be filtered regardless of the year - so that i
can send out the cards on a daily basis.

Is this possibile and can anyone tell me how?

Thanks
Chris

13/09/1940
19/09/1940
25/09/1940
27/09/1940
27/09/1940
13/09/1941
14/09/1941
16/09/1941
17/09/1941
29/09/1941
29/09/1941
16/09/1942
16/09/1942
17/09/1942
19/09/1942
26/09/1942
13/09/1943
16/09/1943
22/09/1943
26/09/1943
27/09/1943
13/09/1944

Filter dates by the day
 

Thank you very much! This is perfect! No more manually sorting out the days
now!

Cheers
Chris

"Allllen" wrote:

Hi Chris,

Dates in column A

Column B would have the formula =MONTH(A1)
Column C would have the formula = DAY(A1)

then you can just sort by column B ascending, column C ascending to get them
in the order you need

HTH
--
Allllen


"Chris AM" wrote:

Excel 2003.

I wish to send my client's birthday cards and am attempting to filter thier
DOB's so that they are ordered from the first of the month to the last.

I'm having a problem as excel only filter the whole date oldest to newest
and doesn't take into account the actual day. EG: - with the list below
excel has filtered using the year.

What I want is for the day to be filtered regardless of the year - so that i
can send out the cards on a daily basis.

Is this possibile and can anyone tell me how?

Thanks
Chris

13/09/1940
19/09/1940
25/09/1940
27/09/1940
27/09/1940
13/09/1941
14/09/1941
16/09/1941
17/09/1941
29/09/1941
29/09/1941
16/09/1942
16/09/1942
17/09/1942
19/09/1942
26/09/1942
13/09/1943
16/09/1943
22/09/1943
26/09/1943
27/09/1943
13/09/1944