Advanced Filter problem

[Michaels]

Hello,

My requirement is to extract Wed, Thu, Sat and Sun (or any other days as required) based on start date and end date. So for example, between the start date of 01/01/2020 and end date of 25/01/2020, I want the dates of Sat, Sun and Mon. That would be dates in one column and days in next column.

I have tried Auto Filter, Advanced Filter and even some formulas. Also I tried VBA but to no avail.

I would appreciate any help to solve this using formula or VBA.

Thank you for your help.

Regards

 

[Michaels]

You are right, and I am wrong