Formula to average all Monday values in a calendar month excluding a holiday

[pbgexcel]

I have a vertical list consisting of every single day in the year and a corresponding price. I'm looking to use AVERAGEIFS() to average only the Monday values in a given month excluding any holidays, the dates for which I have listed elsewhere for reference.

Right now I'm trying to use MONTH()=1 AND WEEKDAY()=1 to specify only the Mondays in January, but to no avail. I also want to exclude 1/1/2018, as New Year's is a holiday, as I have noted in another cell, 'C1', for referencing in the formula. Any ideas how to go about this?

Thanks for your help!

Date	Value
1/1/2018	10
1/2/2018	20
1/3/2018	10
1/4/2018	20
1/5/2018	10
1/6/2018	20
1/7/2018...	10
12/30/2018	20
12/31/2018	10

<tbody>
</tbody>

 

[Dave Patton]

Why didn't you start your own thread?
Which formula did you try?
Can you post a concise example with XL2BB?
Did you try deleting the part or parts of the suggested solution that you do not require