Sum specific range unless date is found in holiday list then Sum Different Range.

[NORRILLOUS]

As seen above I have this week and the beginning of next week. listed with how much product it required. There is also a list of Holidays

My problem is I need to sum Monday to Monday normally, unless those dates include a holiday.
For example, being Monday 5/31 is a holiday I need to sum Monday to Tuesday.

I am confused on where to start.

 

[NORRILLOUS]

View attachment 39536

View attachment 39537
As seen above I have this week and the beginning of next week. listed with how much product it required. There is also a list of Holidays

My problem is I need to sum Monday to Monday normally, unless those dates include a holiday.
For example, being Monday 5/31 is a holiday I need to sum Monday to Tuesday.

I am confused on where to start.

I can Identify if a day is a holiday with

IF(COUNTIF(Lists!$L$2:$L$12,L3)>0,"Holiday","Normal Day")

But I am now stuck again with how to sum one way if "Holiday" is found and sum another in "Normal day" is only found.

 

[NORRILLOUS]

I Found a solution w/

=WORKDAY(TODAY()-WEEKDAY(TODAY(),2),L26,Lists!$L$2:$L$12)

 

[NORRILLOUS]

Thanks for being my sounding board Mr.Excel! I love you!