Add a date range in the Excel report spreadsheet

How to add a daet range so you can just change the data on the Excel Spreadsheet and click on refresh.

Add a date range in the report spreadsheet:
From Start Date
To End date

Go into the data tab, click on Connections

In the workbook connections, select the data connection > Click on properties

Click on Edit Query.


Add in a field 'Reported date' change the date to >=[Parameter1] And <[Parameter2]
=[Parameterl lAnd

Close the query and go into data connection > Click on properties > Go to Definition Tab > Click on Parameters:
Click on 'Get the value from the following cell'
Define the correct cells for Parameter 1 -> start date
Select the correct date for Parameter 2 -> end date