Advanced Filter problem

Michaels

Active Member
Joined
Apr 2, 2009
Messages
404
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
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Watch MrExcel Video

Forum statistics

Threads
1,114,322
Messages
5,547,243
Members
410,781
Latest member
fabalshehhi
Top