Hi everyone, I have a data sheet that has a column of date and time in 1 min interval. Let say today is June 28, but the date in the data is April 1 to May 31. I want to analyze the data in a weekly basis based on the range of date in the column. If I filter by last week in excel I will get June 20 - June 26's data but these date is not in the data.
Is there a way to filter the past 7 days from the max date in the date column? i.e May 26 - May 31's data.
My current code is a result from a recorded macro, I am still learning, any assistance will be greatly appreciated. Thanks!
ActiveSheet.ListObjects("Master").Range.AutoFilter Field:=1, Criteria1:=5, _
Operator:=11, Criteria2:=0, SubField:=0
Is there a way to filter the past 7 days from the max date in the date column? i.e May 26 - May 31's data.
My current code is a result from a recorded macro, I am still learning, any assistance will be greatly appreciated. Thanks!
ActiveSheet.ListObjects("Master").Range.AutoFilter Field:=1, Criteria1:=5, _
Operator:=11, Criteria2:=0, SubField:=0