Thread
:
filter birthday's by month in Excel
View Single Post
#
2
ScottO
Posts: n/a
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
Reply With Quote