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

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Watch MrExcel Video

Forum statistics

Threads
1,113,838
Messages
5,544,603
Members
410,626
Latest member
rkmadasu
Top