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