You can copy/paste the code below into the VB Editor. Please see my post on The Ultimate Guide to Filters in VBA for more details on how to use the AutoFilter method and its parameters. The comparison operators = are also included inside the quotes. It's important to note that the Criteria parameter values are wrapped in quotation marks. The following macro contains examples for basic date filters. This is a weird quirk of VBA that can cause inaccurate results if you don't know the rule. When applying a filter for a single number we need to use the number formatting that is applied in the column. Let's take a look at some code examples for the different date filters. There are also many options for dates in periods (This Month, Next Month, Last Quarter, etc.). This allows us to filter for date ranges like before, after, or between two dates. We can also choose from the Date Filters sub menus.

We can expand and select those check boxes to filter multiple items. The filter drop-down menu list groups the dates by years, months, days, hours, minutes, seconds. We have a lot of options when filtering a column that contains dates. VBA-AutoFilters-Guide.zip Download Date Filters in Excel

Visual basic for excel day of month