Summing Totals Between Dates

[Swept]

I need help summing the total dollar value between two dates with dynamic rows and columns.

I have two tabs: SOURCE and CALCULATION.

SOURCE is a table of names as the Y axis and dates as the X axis with dollar values as the content.

CALCULATION is a table of the same names in the Y axis and Week Ending dates in the X axis. (I.e., where SOURCE may have 1/1, 1/2, and 1/3, CALCULATION will only show 1/7 as the end of the week).

What I need to show: The dollar value associated with a given name (row) during the week ending in the date column.

Some things to note:
1. Not all Week Ending dates appear in the SOURCE table and not all dates in the SOURCE table appear in the CALCULATION table
2. The dates (columns) are not in chronological order. (This is a copy-paste values from a pivot table that pulls from another table. I don't know why the column dates are not in order though the source data is...)
3. Some dates appear in the future so the formula cannot be dependent on TODAY()

I've attached a scrubbed version of the material below.
Book1.xlsx

Any and all suggestions are welcome!

Thank you!

[Jean.P28]

All the date are "1900"

[Swept]

Yes. Hopefully that shouldn't be an issue. I'm unable to share the actual content and used dummy dates. If it's more convenient, assume the year is 2013.

Thanks for looking at it! Any thoughts on how to achieve the desired result?