How to filter date range and how to retrieve data from the specified column that has been filtered based on the selected columns

excel

#1

hi all…
i need your help since i’m new with this UiPath RPA , i’m having trouble to make the following automation process in excel file, can someone help me?
here is my problem:

First, I want to filter the “Status” column to only select the “Closed” description.
(i have filtered the Status column and i did it well)
Secondly, I want to filter the “Date” column to select only the date that matches the date range in “Date Period” (i can’t filter this column)
Thirdly, I want to retrieve data from the “Description” column that has been filtered based on the “Status” column and “Date” Columns, then put the data in Sheet2 into “put the data here” section.

Here is the view of my excel data.

Thank you!
Regards…


#2

Have a look at this on how to work with Date filters