View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chris AM Chris AM is offline
external usenet poster
 
Posts: 1
Default 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