Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced filter using dates | Excel Discussion (Misc queries) | |||
filter dates in data range | Excel Worksheet Functions | |||
Need to pull current dates from list w/many dates | Excel Discussion (Misc queries) | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
how to filter dates? | New Users to Excel |