Type Mismatch when filtering for dates

Hello friends,

I'm trying to filter a database by month and used the codes below:

Please Login or Register  to view this content.

I am bit sure why but I am receiving a 'type mismatch' error when running those codes. I'm not sure why this is happening since everything is in MM/DD/YYYY format.


Thank you so much for reading this.

Have a nice day!

May be


Range("$A$2:$BF$" & Cells("A", Rows.Count).End(xlUp).Row).AutoFilter Field:=2, Operator:=xlFilterValues, Criteria2:=Array(1, Format(DateAdd("m", -1, Date), "mm/dd/yyyy"))

Originally Posted by AB33

May be


Range("$A$2:$BF$" & Cells("A", Rows.Count).End(xlUp).Row).AutoFilter Field:=2, Operator:=xlFilterValues, Criteria2:=Array(1, Format(DateAdd("m", -1, Date), "mm/dd/yyyy"))

Hi AB33,

Thank you so much for your reply, but the problem still persists. I don't understand. The data is of the right type "e.g. 12/29/2017".

It looks like this is the problem: Array(1, Format(DateAdd("m", -1, Date), "mm""/""dd""/""yyyy")

because when I try to get the value from it in the immediate window, the mismatch error appears.

Omg, I found out what the problem is! I used Cells("A", Rows.Count). instead of Cells(Rows.Count,"A").

Can't believe I made such a rookie mistake and got stuck at it for so long!

No need of Format function

Please Login or Register  to view this content.