Hi
I am trying to filter data which is before or after 2 dates (these dates are created using a formula in these cells) stored in different sheet in same workbook.
dates are currently in "dd/mm/yyyy" format but after using below code first date appears in filter as "mm/dd/yyyy" where as second date stays same. both dates needs to stay in same format "dd/mm/yyyy". any help will be much appreciated.
Dim date1 As Date, date2 As Date
date1 = Sheets("summary").Range("A1").Value
date2 = Sheets("summary").Range("B1").Value
Sheets("test").Range("A1").AutoFilter Field:=12, Criteria1:="<" & date1 & "", Operator:=xlOr, Criteria2:=">" & date2 & ""
Bookmarks