Extract items between 2 Date’s criteria

 

Following is the picture of criteria that need to be looked for data that occurs between 1/1/2014 & 12/31/2014
 
img32
 
Press ALT + A + Q for launching advance filter dialog box & follow the below ranges in the fields
 
img33
 
This example will extract the data that contains between the two criteria dates.Refer below snapshot
 
img34
 
ADVANCE FILTER INDEX:

Introduction to Advance Filter
1. Using “And”, “Or” and Multiple Criteria
2. How to Filter Unique Records?
3. How to Use Wildcards?
4. Extract records after specific date criteria
5. Extract items between 2 Date’s criteria
6. How to extract data with specific text?
7. How to extract data to another worksheet using VBA?
 

Download E-Book

 
 



One thought on “Extract items between 2 Date’s criteria

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>