Complie a shopping list from meal planner??

This proposed solution makes several changes to the spreadsheets and uses numerous helpers.
On the Calendar sheet the monthly calendars are stacked vertically and the cells containing the dates for Sundays are actual dates (3/5/17) with custom formatting d applied.
On the Options sheet the date of the Sunday for the week in question needs to be entered in B1,
The rest of the row will fill by formula by use of addition and the range B2:H6 populates using the formula:

Formula:

Please Login or Register  to view this content.

The range A9:A107 is populated using the formula:

Formula:

Please Login or Register  to view this content.

The ingredients were separated using the 'Text to Column' feature, delimited by comma.
The range B111:H130 is populated using the array entered formula*:

Formula:

Please Login or Register  to view this content.

The range A251:F270 is populated by the formula:

Formula:

Please Login or Register  to view this content.

The range J252:J270 is populated using the array entered formula*:

Formula:

Please Login or Register  to view this content.

On the Shopping lists Sheet the following formula populates the shopping list: =Options!J252
*Array entered formulas are activated by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
An effort is made to use simpler formulas so as to make the least amount of reduction in the performance of the workbook, however it is suggested that you complete the menu on the Calendar sheet before entering a new date on the Options sheet. It may become necessary to change the calculation mode of the workbook from Automatic to Manual.
Let us know if you have any questions.

You're Welcome and thank you for the feedback. If you feel that your question has been answered please take a moment to mark the thread as 'Solved' using the thread tools link above your first post, you can undo that designation later if needed. I hope that you have a blessed day.

I moved a few things around and added some color coding just for my own ease of use. I also made it so I can generate shopping lists for 4 weeks at once instead of just 1.

The date for each shopping list is input in the box at the top-right rather than on the "options" tab.

The only remaining issue I'm having is that it won't recognize the dates from the lower calendar for some reason. I tried to edit the array from A1:A38 to A1:A75 but I couldn't get it to work.

I like all the functionality but just wanted to be able to see 2 months at a time to see trends. And for some reason, if a meal is repeated during a given week, it doesn't show up on the shopping list because the array only looks for meals with a qty of "1". I tried changing it to ">0" but it didn't like that.

Also, I haven't yet tried to insert new lines on the options page to add new meals. Hope that doesn't throw anything off.

The only remaining issue I'm having is that it won't recognize the dates from the lower calendar for some reason. I tried to edit the array from A1:A38 to A1:A75 but I couldn't get it to work.

I think that I have sorted out this issue, however more testing will surely be needed.
Let us know if you have any questions.

The file looks very useful, thanks for sharing. I hope that you have a blessed day.