Home |
Search |
Today's Posts |
#1
|
|||
|
|||
filter birthday's by month in Excel
I have tried the above by auto filtering, then custom filter, however when i
type for example ??/07/?? or **/07/** nothing works. Could you please tell me how to filter birthday's by month as soon as possible. Kind regards, Lisa Peterson |
#2
|
|||
|
|||
I don't know a way to do it directly. As a work-around, you could add a
column and fill it down with the formula (assuming the dates are in ColA, starting at A2) =month(A2). Then filter the database based on the new column. Rgds, ScottO "Lisa Peterson" <Lisa wrote in message ... | I have tried the above by auto filtering, then custom filter, however when i | type for example ??/07/?? or **/07/** nothing works. Could you please tell | me how to filter birthday's by month as soon as possible. | | Kind regards, | | Lisa Peterson |
#3
|
|||
|
|||
If your birthdays are in column B, for example, type the formula
'=MONTH(B2)=7' (replace B2 with the reference of the top data cell in your birthday date column) in a cell to the right of your data, this cell must have a blank cell above it. Click on Data - Filter - Advanced Filter, set the top box to your range of data to be filtered and the second box to the cell containing the formula and the blank cell above (e.g. F1:F2). When you click OK the list should be filtered. Click on Data - Filter - Show All to remove the filter. See http://www.allaboutoffice.co.uk/exfilter.htm for more on using Advanced Filters. Andrea Jones http://www.allaboutoffice.co.uk http://www.stratatraining.co.uk http://www.allaboutclait.com "Lisa Peterson" wrote: I have tried the above by auto filtering, then custom filter, however when i type for example ??/07/?? or **/07/** nothing works. Could you please tell me how to filter birthday's by month as soon as possible. Kind regards, Lisa Peterson |
#4
|
|||
|
|||
I'd use a helper column full of formulas.
If the dates are in column A: =text(a2,"mmddyyyy") and drag down. Then sort by that column. It'll sort by month, day, and finally year. ps. Are you my sister-in-law? Lisa Peterson wrote: I have tried the above by auto filtering, then custom filter, however when i type for example ??/07/?? or **/07/** nothing works. Could you please tell me how to filter birthday's by month as soon as possible. Kind regards, Lisa Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
colorsetting of the Excel filter knob | Excel Discussion (Misc queries) | |||
In Excel, look at a date field and return just the month.. | Excel Discussion (Misc queries) | |||
Can't group pivot table items by month in Excel | Excel Discussion (Misc queries) | |||
Excel: Is there a way to calculate the date as week of month? | Excel Discussion (Misc queries) |