Filter Dates Between Two Dates in Excel: Step-by-Step Guide

When working with sales reports, order records, attendance sheets, project logs, or financial data in Excel, you may often need to display only the records that fall within a specific date range. For example, you may want to filter all orders placed between February 1, 2026 and March 31, 2026, or view all transactions within a selected month.

Excel provides several ways to filter dates between two specific dates. In this article, we will show you several practical methods to filter dates between two specific dates in Excel.

Filter Dates Between Two Dates in Excel

• Method 1: By Filter command
• Method 2: By Advanced Filter
• Method 3: By Kutools for Excel
• Method 4: By FILTER Function (Excel 365 or Excel 2021 and later versions)

Tips for Filtering Dates Correctly in Excel

Conclusion

Filter Dates Between Two Dates in Excel

Fortunately, Excel offers several ways to filter dates between two specific dates. You can use the built-in Date Filter for quick filtering, the FILTER function for dynamic results, Advanced Filter when you want to extract matching records to another location, or Kutools for Excel for a simpler and more visual solution. In the following sections, we’ll introduce each method step by step, so you can choose the best option based on your Excel version, data size, and filtering needs.

Method 1: Filter Dates Between Two Dates with Filter command

The easiest way is to use Excel’s built-in Filter feature. This method is suitable when you want to filter data manually without using formulas.

1. Select your data range, including the headers. Go to the Data tab, click Filter.
   
2. Click the drop-down arrow in the Order Date column. Choose Date Filters > Between.
   
3. In the Custom AutoFilter dialog box:
   • Select is after or equal to and enter the start date, such as 2/1/2026.
   • Select is before or equal to and enter the end date, such as 3/31/2026.
   • Click OK.
     

Now, Excel will only display the rows where the date falls between the two specified dates.

Method 2: Filter Dates Between Two Dates with Advanced Filter

If you want to filter records by a date range and copy the matching results to another location, Excel’s Advanced Filter is a useful option. Unlike the regular Date Filter, Advanced Filter allows you to set up criteria in worksheet cells and then filter the data based on those conditions. This method is especially helpful when you need to create a separate report, extract records for a specific period, or keep the original data unchanged while displaying the filtered results elsewhere.

1. Create a criteria range in an empty area of the worksheet.
   
   Important:
   The criteria headers must be exactly the same as the original date column header.
2. Select your original data range. Go to the Data tab and click Advanced in the Sort & Filter group.
   
3. In the Advanced Filter dialog box:
   1. Select Filter the list, in-place if you want to filter the original data. Or select Copy to another location if you want to extract the matching records elsewhere.
   2. In the List range box, select your source data. In the Criteria range box, select the criteria range you created. If you choose Copy to another location, select a destination cell.
   3. Click OK.
      

Excel will filter or extract the records that fall between the two dates.

Method 3: Filter Dates Between Two Dates with Kutools for Excel

If you frequently filter data by date ranges, Kutools for Excel provides a more convenient way to filter dates with fewer steps.

With Super Filter, you can create flexible filter conditions such as dates between two specific dates, text contains, number ranges, and more.

1. Select the data range you want to filter. Click Kutools Plus > Super Filter.
   
2. In the Super Filter pane, Set the first condition:
   • Date column: Order Date
   • Condition: is greater than or equal to
   • Value: your start date, such as 2/1/2026
   • Click OK.
   • 
3. Add another condition:
   • Date column: Order Date
   • Condition: is less than or equal to
   • Value: your end date, such as 3/31/2026
   • Click OK.
     
4. Finally, Click Filter button.

Kutools will quickly show only the rows where the dates are between the two specified dates.

Method 4: Filter Dates Between Two Dates with FILTER Function

If you are using Excel 365 or Excel 2021, you can use the FILTER function to dynamically extract rows between two dates. This method is especially useful when you want the filtered result to update automatically after changing the start date or end date.

Enter the following formula in an empty cell:

=FILTER(A2:D13,(C2:C13>=A18)*(C2:C13<=B18),"No records found")

Then press Enter key, Excel will return all matching records automatically.

Tips for Filtering Dates Correctly in Excel

Conclusion

Filtering dates between two specific dates in Excel is a common task when working with reports, orders, transactions, schedules, or project records. For quick filtering, the built-in Date Filters > Between option is the easiest choice. If you want a dynamic result, the FILTER function is ideal for Excel 365 and Excel 2021 users. For older Excel versions, Advanced Filter can also work well.

For users who want a simpler and more visual way to apply multiple date conditions, Kutools for Excel provides an easier solution with its Super Filter feature, helping you filter date ranges quickly without complex formulas or manual setup.