I'm brand new to vba. I was able to create a pivot table without too much hassle, but I'm struggling with flitering a pivot field with a formula.

I need to show all pivot items that match the below:
1. Any blank dates (fields) that do not have "Certificate" in the name
2. Any expired dates
3. Any dates that fall between 2 specific dates (these dates are determined by adding/subtracting 2 months from the expiration date)

I can create the formula in an excel spreadsheet but am struggling with getting it to work in VBA.
Please Login or Register  to view this content.
G2 = Expiration Date
I2 = Certification Name

Here is what I tried to do:

Please Login or Register  to view this content.
The "pi.Name" keeps giving me a Type Mismatch error.

Let me know if you need my entire code. Any help is appreciated. Thanks!!!