Excel VBA Code to Apply Dynamic Date Filters to an Excel Table

This video details the Excel VBA Code to Apply Dynamic Date Filters to an Excel Table.
------------------------

[tienphamthanh]

How about specific days, months, and years

[yisrael]

Hello, how do you filter all the dates prior to today's date?

[lucaslimo]

Any chance I could do this but for yesterday? Like xlFilterToday - 1?

[donjr]

Hi, thank you for the video. Should I want to filter to retrieve records that are 6 months later from today's date, how should I go about? Need some help!

[Pro-gamer_]

Can we apply VBA addition days code on user filter selection?

[jeanpierre]

Hi, I want to do this, however I want a filter between two numbers, & apply it to extract the numbers between from a database

[MARQUITOSGUALACBA]

how can I get the first field in a column after the filter?

[futuresuperstarlife]

I NEED HELP! PLZZ
im trying to do something similar but more specific i guess.
im a server and ive been working on an excel file to track my tips and sales percentages tip outs etc, it's very complex and im completely new to excel so it took me like two months.
i'm trying to recreate an app that i was using but doesn't track enough details.
in this app there are tabs on top for sorting the data yearly, monthly, weekly and biweekly and "all"
and then at the bottom you can toggle between all of the data with arrows, between the 2 arrows there are 2 dates based off of the filter (the corresponding dates of the month, the week etc) but youre not limited to just "this month" and "last month", but you can continue to toggle between all months by clicking the arrow.
i've tried with slicers and it kind of works but not as efficient or specific as i'd like it to be
PLEASE TELL ME if you think that is at all possible on excel
can i do this with this vba code???

[mihneanedelcu]

Hi, Chester,

Where do you open the VBA window from?