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
|