VBA to filter from today's date + 4 business days

**kop1ko** · 05-18-2016, 08:04 PM

Hello gurus,

I just want to filter my data from today's date + 4 business days.

for example if today's date is 5/19/2016, the filter should be from 5/19/2016 - 5/252016

I've attached my file.

Thanks in advance!

**alansidman** · 05-18-2016, 08:10 PM

If you use the Data Filter Icon on the Ribbon, you can then filter using the between command in the drop down when you click on the down arrow in the date column. There is no need for a Macro when this functionality is built into Excel.

**kop1ko** · 05-18-2016, 08:29 PM

Hi Alan,

Yes i know that, but i want it to be automated.

**alansidman** · 05-18-2016, 11:00 PM

Record a Macro and then if it does not do exactly what you want, post it here for tweaking.

**kop1ko** · 05-19-2016, 07:20 AM

Anyone can help me please?

I've record a macro and I came up with this but I want to be flexible/dynamic

Please Login or Register  to view this content.

VBA to filter from today's date + 4 business days

LinkBack

Thread Tools

Rate This Thread

Display

VBA to filter from today's date + 4 business days

Re: VBA to filter from today's date + 4 business days

Re: VBA to filter from today's date + 4 business days

Re: VBA to filter from today's date + 4 business days

Re: VBA to filter from today's date + 4 business days

Thread Information

Users Browsing this Thread

Similar Threads

# of business days between timestamp & another date

vba to filter table by today's date up to 10 days. and save as new version

[SOLVED] First add business days to a date (excluding weekends and holidays), then add regular days

[SOLVED] Create a macro to filter between today and the next 30 days

Due date is 6 business days

business days - trade date plus 3

[SOLVED] business days between 2 date feilds

Bookmarks

Bookmarks

Posting Permissions