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

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Watch MrExcel Video

Forum statistics

Threads
1,113,904
Messages
5,544,978
Members
410,647
Latest member
LegenDSlayeR
Top