Extract records between two dates

In this example, you can type a date in cell B1 and B2. Press the button and the table is instantly filtered. Copy the vba code below into a standard module. Create a button and assign the macro.

VBA code

Sub TblFilterDates()

Worksheets("Sheet3").ListObjects("Table13").Range.AutoFilter _
Field:=1, Criteria1:=">=" & Worksheets("Sheet3").Range("B1") _
, Operator:=xlAnd, Criteria2:="<=" & Worksheets("Sheet3").Range("B2")
End Sub

Where to copy vba code?

Press Alt+F11
Insert a new module
Copy paste code into code window

How to create a button

Press with left mouse button on "Developer" tab
Press with left mouse button on "Insert" button
Create a button (form control)
Press with right mouse button on on the button
Assign your macro

Get excel sample file for this tutorial.

filter-records-between-two-dates.xlsm
(Excel 2007 MacroEnabled Workbook *.xlsm)

Match two criteria and return multiple records

Question: I have a table of 3 columns (Security name, date, price) and I have to find the price of […]

Extract all rows from a range that meet criteria in one column

Lookup with criteria and return records.

Search for a text string in a data set and return multiple records

This article explains different techniques that filter rows/records that contain a given text string in any of the cell values […]

Extract records where all criteria match if not empty

Question: I second G's question: can this be done for more than 3? i.e. (Instead of last name, middle, first) […]

Extract all rows that contain a value between this and that

Question: I have a list and I want to filter out all rows that have a value (Column C) that […]

How to extract rows containing digits [Formula]

This article describes a formula that returns all rows containing at least one digit 0 (zero) to 9. What's on […]

Extract records containing negative numbers

Table of Contents Extract negative values and adjacent cells (array formula) Extract negative values and adjacent cells (Excel Filter) Array […]

Filter records based on a date range and a text string

Murlidhar asks: How do I search text in cell and use a date range to filter records? i.e st.Dt D1 […]

Comments (7)

7 Responses to “Extract records between two dates”

Tom says:

September 15, 2011 at 8:33 am

This is a great piece of programming, but I cannot for the life of me get it to work in my spread sheet. I have tried naming the ranges, adding dollar signs to keep the references constant, etc., but no matter what I do, it will not filter the date range correctly.

This is the perfect solution to my need, so if there is anything you can do to help me, I would appreciate it. I could send you the spreadsheet if that would help.

Thanks

Tom

Reply
Oscar says:

September 16, 2011 at 10:06 am

Tom,

I have updated the article. Let me know if you got it to work?

Reply
AVIUSHEK says:

October 12, 2011 at 5:15 am

Sir
What is table 13 here?

Reply
Oscar says:

October 12, 2011 at 12:03 pm

AVIUSHEK,

Table 13 is the table name.

How to find the table name
1.Select your table
2.Click "Design" tab on the ribbon
3.Read table name in properties window on the ribbon

Reply
scott says:

September 8, 2015 at 4:30 pm

I am trying to use your filter-records-between-two-dates.xls Excel 97-2003 Workbook *.xls and use the #num errors removal but the returned value is #NAME? instead, can you tell me what I am doing wrong?

Reply
izeblood says:

February 3, 2017 at 3:47 am

how to add data for Table13

Reply
Kadr Leyn says:

January 4, 2021 at 9:36 pm

Thanks for tutorial.

I developed a template to filter products between two selected dates using the userform. The filtered products are listed in the listbox. The selected products from the listbox are copied to the other worksheet.

It's image: https://imgur.com/DpkkYDq

To make the date selection easier, I added a date userform (second userform) instead of a calendar control. When clicked the textboxes on the main userform, the date userform is opened and the user can easily select the date.
Also, I applied the elongation effect to the userform at the time of filtering.

Source codes and sample file at:https://eksi30.com/filter-products-between-two-dates-with-vba-userform/

Reply

How to comment

How to add a formula to your comment
<code>Insert your formula here.</code>

Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >

How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.

Contact Oscar

You can contact me through this contact form