<div>
You can achieve that with Advanced Filter. I will do it on the file and post shortly
</div>


<div>
You actually have a couple of options, you can use AutoFilter or Advanced Filter on the list.<br />
<br />
<b>Auto Filter</b><br />
Select the list of entries and from the Data tab click the big Filter/Funnel icon. This will place dropdown arrows beside each header. From the Last Date header dropdown select: <br />
<br />
Date Filters &gt;&nbsp;Before &gt;&nbsp;Enter 21/11/17 &nbsp;click OK.<br />
<br />
Downside of this is that you need to know what date you are filtering on, today + 20 days is relatively easy to calculate but other scenarios may not be.<br />
<br />
<b>Advanced Filter</b><br />
<br />
Advanced Filter does the calculation for you by specifying a criteria and you can specify which columns to copy into extracted list.<br />
<br />
The Advanced Filter requires 3 pieces of information:<br />
<br />
1) Data list - to be selected<br />
2) Criteria - see below<br />
3) Destination (optional as can be filtered in place)<br />
<br />
Criteria - the criteria is listed in a secondary table with the same headings as some (or all) of the columns of the source data. In this instance we are just using &quot;Last Date&quot;. The criteria table is laid out as a header (the same as the source column) and then criteria listed beneath it. In this instance there is only one criteria and it will be a formula:<br />
<br />
=&quot;&lt;=&quot;&amp;TODAY()+20<br />
<br />
This will show as &lt;43059 &nbsp;because 43059 is the serial number for today + 20<br />
<br />
3) Destination - if you want to extract the data to a separate list you will need to specify where. You can also specify which columns to extract by using the same column headers as the source data. They can also be in a different order if required. If this is to be on a separate sheet, you will need to be on that sheet when you start the wizard.<br />
<br />
To start the wizard, select the list of entries and from the Data tab select the Advanced button (smaller button next to big funnel for Auto Filter). The wizard will show and you will see the requirement for the 3 pieces of information as mentioned above. The &quot;Copy to&quot; (Destination) option will be greyed out until you tick the option for &quot;Copy to another location&quot;. Use the range browser icons at the end of each selection to select your data (if not already selected), your criteria table and your destination. Click OK and the required data will be copied or the data will be filtered in place if you did not choose the Copy To option and set a location.<br />
<br />
See attached file. One query with what you were expecting as a result. Why is Name15 included in the list when it is beyond 20 days from today?<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/10_w44/1202302/Filter-Problem.xlsx" target="_blank" class="file-inline" title="Advanced Filter (12 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Filter-Problem.xlsx</a>
</div>


Filter-Problem.xlsx

<div>
Thx, but I tried something similar. I need something different, my plan is that, data in &quot;how it is&quot; sheet use for input, in sheet &quot;how it's should be&quot; generate table with specific condition and use that table in main report table.
</div>


<div>
I did it with advance filtering, but there was some tricky part about &quot;active sheet&quot;
</div>


<div>
Yes, when starting the wizard the cursor has to be on the sheet where you want the results.
</div>


<div>
<div class="content wysiwyg-content">
How to extract a list of values filtered by criteria &quot;=today()+20&quot;<br />
<br />
In atach is .xlsx with my problem<br />
<br />
Thank you in advance<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/10_w44/1202290/Problem.xlsx" target="_blank" class="file-inline" title="Excel problem (11 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Problem.xlsx</a>
</div>
</div>


Problem.xlsx

How to extract a list of values filtered by criteria "=today()+20"

In atach is .xlsx with my problem

Thank you in advance

How to extract a List of Values Filtered by Criteria in excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.