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!
[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Value[/TD]
[/TR]
[TR]
[TD]1/1/2018[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]1/2/2018[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]1/3/2018[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]1/4/2018[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]1/5/2018[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]1/6/2018[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]1/7/2018...[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]12/30/2018[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]12/31/2018[/TD]
[TD]10[/TD]
[/TR]
</tbody>[/TABLE]

 

[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