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.

 

[ngocanh87]

Thank all so much, I try this vba it ok

Sub TtoC()
With Range("H2:H" & Cells(Rows.Count, "H").End(xlUp).Row)
.TextToColumns Destination:=Range("H2"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _
Semicolon:=False, Comma:=False, Space:=False, Other:=False, FieldInfo _
:=Array(1, 5), TrailingMinusNumbers:=True
.NumberFormat = "mm/dd/yyyy"
End With
End Sub