Filter get these days = Now - 5 days (by vba)

[ngocanh87]

Hello all,

I searched the forum but couldn't find this question, as the titles I want filter get these days = Now - 5 days (by vba)
Today 16 Feb, I want to filter get 15,14,13,12,11.

 

[Legacy 143009]

Select your Range according to your data. Filed 9 is for Column I.

    Range("$A$1:$J$100").AutoFilter Field:=9, Criteria1:=">=" & Now-5, Operator:=xlAnd, Criteria2:="<" & Now

 

[ngocanh87]

Work perfectly. thank so much

 

[Legacy 143009]

Glad it did work. Thanks for the feedback

 

[ngocanh87]

Select your Range according to your data. Filed 9 is for Column I.

    Range("$A$1:$J$100").AutoFilter Field:=9, Criteria1:=">=" & Now-5, Operator:=xlAnd, Criteria2:="<" & Now

Hi,

After fillter it as below but I want Date not have Time (ex: 17/02/2023 & 22/02/2023) Thank you

 

[Legacy 143009]

This should work:

    Range("$A$1:$J$100").AutoFilter Field:=9, Criteria1:=">=" & Date(Now)-5, Operator:=xlAnd, Criteria2:="<" & Date(Now)

 

[ngocanh87]

Error:

 

[Legacy 143009]

Try:

    Range("$A$1:$J$100").AutoFilter Field:=9, Criteria1:=">=" & Date()-5, Operator:=xlAnd, Criteria2:="<" & Date()

 

[MARK858]

Try changing the words Now to CLng(Date)

 

[ngocanh87]

Hello,

Sorry I want asked more, Column I is Text and when I run vba it can;t correct, how can I convert Date (dd/MM/YYYY). Thank you