Function Problems

Print Excel Table Rows for a User-Selected Date Range

Amos GikundaAmos Gikunda Nov 18, 2026 869 views

Question details

Create a print sheet that displays only Excel table rows between user-selected start and finish dates.

Print Excel Table Rows for a User-Selected Date Range
Product
Microsoft Excel
Device & OS
not provided
Scenario
A user wants to enter a date range and print matching rows from a table.
Observed behavior
The print sheet should update to show rows whose dates fall within the selected range.
Before you start

Check that the source table has a Date column containing real Excel dates rather than text. The FILTER formula requires an Excel version that supports dynamic arrays.

Solution 1Recommended

Use FILTER to create a date-range print sheet in Excel

Use this method to update the print sheet automatically when the selected dates or source table rows change.

1
Name the source table

Select a cell in the source table, open Table Design, and check its Table Name. For the formula below, use tblQ1 and a column named Date, or substitute your own table and column names.

2
Create named date cells

On the print sheet, enter the start and finish dates in two cells. Select the start-date cell and type Start in the Name Box beside the formula bar; name the finish-date cell Finish in the same way.

3
Add headings and the formula

Copy the source table headings to row 4 of the print sheet. In A5, enter =FILTER(tblQ1,(tblQ1[Date]>=Start)*(tblQ1[Date]<=Finish),"No Rows"). Leave the cells below and to the right clear so the results can spill.

4
Print the results

Change the Start and Finish cells to the requested dates, then open File > Print and preview the print sheet before printing.

Use FILTER to create a date-range print sheet in Excel
If dates include times: The formula above includes date-only values through Finish. If the Date column contains times, replace tblQ1[Date]<=Finish with tblQ1[Date]<Finish+1 to include the entire finish date.
Print selected date ranges

Filter and print a date range in WPS Spreadsheets

Use the date-column filter in WPS Spreadsheets to display matching rows, then print the filtered sheet.

  1. 1. Open the workbook: Open the Excel workbook in WPS Spreadsheets and select the sheet containing the table.
  2. 2. Enable filtering: Select a cell in the table and choose Data > Filter, if filter arrows are not already visible.
  3. 3. Set the date range: Open the Date column's filter arrow and choose a custom date filter. Set conditions for dates greater than or equal to the start date and less than or equal to the finish date, joined by AND.
  4. 4. Preview and print: Confirm that the visible rows match the requested range, then choose File > Print to preview and print the sheet.
Filter table rows to a selected start and finish dateOpen and edit Microsoft Excel XLS and XLSX filesPreview the filtered sheet before printingUse a familiar spreadsheet interface
microsoft office alternative - wps office

Frequently Asked Questions

Will the Excel formula include newly added table rows?

Yes. The structured reference tblQ1 expands as rows are added to the table. Add the rows within the Excel table and keep the print sheet's spill area clear.

Why does the print sheet show No Rows?

No source rows match the entered range. Check that Start is not later than Finish and that the Date column and named cells contain real Excel dates.

What does a #SPILL! error mean?

The FILTER results need more empty cells. Clear any content blocking the output below or to the right of A5, then check the formula again.

How do I include entries with times on the finish date?

In the FILTER formula, use tblQ1[Date]<Finish+1 instead of tblQ1[Date]<=Finish. This includes all times before the next day.

Can I use this formula in an older version of Excel?

FILTER requires a version of Excel that supports dynamic arrays. In an older version, use the Date column's filter controls to select the range and print the visible rows instead.