I am Having so many Excel files inside the folder. The Excel file name is having different date like ‘ExtractedFile_09212020’.,‘ExtarctedFile_09282020’ etc…,
I attached the image kindly refer.
I already extracted the date from this excel file name…
Now My requirement is, From the folder I need to process the excel , which is based on only If the name of the excel File name date contains one of the before one week date like consider from the current date.
Can anyone Guide me please?