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