Hello everyone.

I need some help in figuring out how to get Excel VBA to filter a
record for a specific month.

I'm trying to code a macro that will generate a list of all employees
born in a certain month and Excel keeps adding 2007 to my filter.
I've tried with just dd/mm, using the Month(1) function and a bunch of
other little things.

Any ideas what I'm doing (or not doing) wrong?

Thanks in advance!

(My example code)

Worksheets("CustomReports").Range("B1").Value = "Date of Birth"
Worksheets("CustomReports").Range("B2").Value = "January"