Move Excel Records to Another Sheet by Date Range
Question details
Display aircraft records from multiple hangar sections on another sheet for a selected week.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Aircraft records are on a source sheet, and the user wants a separate sheet to show rows within a chosen date range.
- Observed behavior
- The destination sheet should show only records dated within the selected week.
Check that the aircraft dates are real Excel dates, not text, and confirm which column contains them. The formula below assumes the source sheet is named Aircraft Data, dates are in column D, and the source data occupies columns A through Z.
Use FILTER to display records for the selected week
Use this approach in a version of Excel that supports the FILTER function to update the destination sheet when the dates or source records change.
The start date is inclusive and the end date is exclusive. Setting the end date to the day after the desired period includes records with times on the final day.
FILTER displays matching records; it does not remove them from the source sheet.
On the destination sheet, enter the first day of the week in A1 and the day after the last day in B1. For February 5 through February 11, enter February 5 in A1 and February 12 in B1.
Select A3 on the destination sheet and enter =FILTER('Aircraft Data'!A2:Z1000,('Aircraft Data'!D2:D1000>=A1)*('Aircraft Data'!D2:D1000<B1),"").
Press Enter and leave the cells below and to the right of A3 empty so matching rows can spill into them. Change A1 or B1 to display a different period.
If your sheet name, date column, or data range differs, edit the formula in A3 to match. Keep the filtered data range and both date ranges the same height, and extend them beyond row 1000 if needed.

Filter aircraft records by week in WPS Spreadsheets
Open the workbook in WPS Spreadsheets and use FILTER, if supported by your version, to display aircraft records for a selected week on another sheet.
- 1. Open the workbook: Open the Excel workbook in WPS Spreadsheets and select or create the destination sheet.
- 2. Set the dates: Enter the first day of the desired week in A1 and the day after its final day in B1.
- 3. Enter the filter formula: In A3, enter =FILTER('Aircraft Data'!A2:Z1000,('Aircraft Data'!D2:D1000>=A1)*('Aircraft Data'!D2:D1000<B1),""). Adjust the sheet name and ranges to match your workbook.
- 4. Review and save: Press Enter, check that the matching rows appear, and use File > Save As to save the workbook. If FILTER is not supported in your version, use Data > Filter on the source date column and copy the matching rows to the destination sheet.

Frequently Asked Questions
Why is the end date set to the day after the week ends?
The formula uses dates less than B1. Setting B1 to the next day includes every time on the final day, while excluding records from the next day.
Will the filtered records update when I change the week?
Yes. In Excel versions that support FILTER, change the dates in A1 and B1 on the destination sheet, and the formula in A3 recalculates.
Why does the formula show a spill error?
The results need empty cells below and to the right of A3. Clear any content blocking the output range, then check the formula again.
What if the formula does not find dates that look correct?
Check whether the values in the source date column and cells A1 and B1 are actual dates rather than text. Also confirm that the formula refers to the correct date column and source rows.




