Dynamic Date Filter - PowerQuery

Shreesurya

New Member
Joined
Jul 7, 2014
Messages
42
Hi,

I am trying to filter a column with the recent 3 Business days (Including Holidays and Weekends) based on Max date in the Column and the filter should also include the Blank Cells in the column.

For Example, the Column max date is 9th September and I would like to create a filter whichever is after 4th September including Weekend and holiday and it should also include the blank cells.

Please help me out with this.
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Watch MrExcel Video

Forum statistics

Threads
1,108,743
Messages
5,524,569
Members
409,587
Latest member
ChrisF1980

This Week's Hot Topics

Top