I have two tables. One Table has Weekly Sales by Store and by Week. Our week starts on a Saturday and ends on a Friday. The second table defines the week and all the dates within it.
Is there a way to use both tables so I can come up with average sales across all the different days. Sales differ by week and so the daily average would be different if spread across the days.
The use case of this dataset would be to upload it to another system that only accepts sales by day instead of week.
I have uploaded an example. Columns A-C represent the first table. Columns E-F represent the second table. Columns H-J represent the results I am looking to achieve.