Advanced filter - return last business day of each week - holidays accounted

[ScorpionHaven]

Hello,

I would like to filter raw data so that it returns the last business day of each week with holidays accounted. Below is the data set:

2015-01-06 Tue
2015-01-05 Mon
2015-01-02 Fri
2014-12-31 Wed
2014-12-30 Tue
2014-12-29 Mon
2014-12-24 Wed
2014-12-23 Tue
2014-12-22 Mon
2014-12-19 Fri
2014-12-18 Thu
2014-12-17 Wed

The criteria I've applied to the advanced filter is '=AND(WEEKDAY(E2,2)<6,WEEKNUM(WORKDAY(E2,1,Holidays!$C$2:$C$147))<>WEEKNUM(E2))'. Holidays included 25 and 26 Dec 14.

The result is:
Fri 02 Jan 15
Wed 31 Dec 14
Fri 19 Dec 14

The required result is:
2015-01-02 Fri
2014-12-24 Wed
2014-12-19 Fri

Please let me know if I've made an error or if there are alternate ways for me to obtain the correct result. Thanks for your help in advance.

[CK76]

Result and your requirement looks to be same?

It's just formatting difference it looks like. If that isn't the case, I'd recommend uploading sample workbook that replicates your issue (see yellow banner at the top).

[ScorpionHaven]

Please find attached my spreadsheet.

The required result is:
2015-01-02 Fri
2014-12-24 Wed
2014-12-19 Fri

The extra record from the advanced filter that I'm trying to remove is 31 Dec 14.

[Bo_Ry]

Please try at G3
=IFERROR(INDEX($A$1:$A$13,AGGREGATE(15,6,ROW($A$2:$A$13)/($A$2:$A$13=WORKDAY($A$2:$A$13+7-WEEKDAY($A$2:$A$13),-1,$C$2:$C$5)),ROWS(G$3:G3))),"")

[ScorpionHaven]

That formula worked but it didn't seem to work for a larger data set.

My apologies not making it clear. I need the filter to return the date (columns A) and associated value (column B).

Please see attached for the complete data set where I'm trying to return the applicable cells from columns A and B. I've highlighted some of the returns that are incorrect.

[ScorpionHaven]

Please ignore my last email as I've solved my query. Instead of using '<>' in the second logical requirement, I've used '>'.

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.