Reference previous weekday to exclude holidays

I am trying to compare values from this week to last week with the exception that will overlook holidays. ie, from Monday to last Monday. But I am running into an issue if there is a holiday in the week as my formulas are looking for the value 5 days prior to the current day.

I think the sample will give you a clearer look at the problem.

Jim O

MOD: original attachment removed to avoid confusion - see latter post for correct file