Go to sales order menu, in the search box, click on "Advanced Search".

You can choose between creation date or confirmation date that you want to use, set it as "greater than", in the date field, set it as the starting date. Click Apply

Repeat the same step as above, but this time set the parameter as "less than", in the date field, set as the ending date. Click Apply. Then, check all the order and export.