9 Responses to “Extract records between two dates”

1. 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

2. Oscar says:

   September 16, 2011 at 10:06 am

   Tom,

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

3. AVIUSHEK says:

   October 12, 2011 at 5:15 am

   Sir
   What is table 13 here?

4. 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.Press with left mouse button on the "Design" tab on the ribbon
   3.Read table name in properties window on the ribbon

5. 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?

6. izeblood says:

   February 3, 2017 at 3:47 am

   how to add data for Table13

7. 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 press with left mouse button on 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/

8. Brittany says:

   December 19, 2022 at 9:03 pm

   Thank you for the tutorial! I've got this working, but would like to add in another criteria, i.e., return row with date between start date and end date and name = cell value. I added it in the 'if' criteria and get the correct number or rows returned, but not the correct rows. How do I specify this?

   • Oscar says:

     December 22, 2022 at 9:13 am

     Brittany,

     Add another logical expression to this formula:

     =INDEX($A$2:$B$38, SMALL(IF(($A$2:$A$38<=$H$2)*($A$2:$A$38>=$H$1), MATCH(ROW($A$2:$A$38), ROW($A$2:$A$38)), ""), ROW(A1)), COLUMN(A1))

     I have bolded the original logical expressions in the formula above.

     If you have a name in cell H3 and names in cells $C$2:$C$38 the formula becomes:

     =INDEX($A$2:$C$38, SMALL(IF(($A$2:$A$38<=$H$2)*($A$2:$A$38>=$H$1)*($C$2:$C$38=$H$3), MATCH(ROW($A$2:$A$38), ROW($A$2:$A$38)), ""), ROW(A1)), COLUMN(A1))

     Excel 365 users using the example values in section 2 use this formula:
     =FILTER(A2:C38,(A2:A38<=H2)*(A2:A38>=H1)*(C2:C38<=H3))

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 &lt; and > becomes &gt;

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