Filter By Last 3 days or 3 Business Days

[Shreesurya]

Hi Excel Experts,

Need your help on filtering the column by last 3 business days or days plus Blank Cells in a column.

If 3 days doesn't meet the requirements then it has to filter 3 business days and it has to be dynamic based on the recent dates in column.

Could you please help me with VBA Code for it...

Thank you

 

[Darren Bartrup]

You could add an extra column to calculate the days.

If your date column is in C2:C6 try =NETWORKDAYS(C2,TODAY()) in D2 and drag down.
You can then filter this column to <=3 or if you're on 365 you can use =FILTER($B$2:$C$6,$D$2:$D$6<=3) providing your data is in B2:C6 with a helper column in D2:D6.

You could update column D formula to =IF(C6="",0,NETWORKDAYS(C6,TODAY())) to take into account blank cells.

Use =NETWORKDAYS.INTL if your weekend isn't Saturday/Sunday.

 

[Shreesurya]

You could add an extra column to calculate the days.

If your date column is in C2:C6 try =NETWORKDAYS(C2,TODAY()) in D2 and drag down.
You can then filter this column to <=3 or if you're on 365 you can use =FILTER($B$2:$C$6,$D$2:$D$6<=3) providing your data is in B2:C6 with a helper column in D2:D6.

You could update column D formula to =IF(C6="",0,NETWORKDAYS(C6,TODAY())) to take into account blank cells.

Use =NETWORKDAYS.INTL if your weekend isn't Saturday/Sunday.

Thank you so much....