Okay, so I've asked AI this question, and I keep getting formulas that simply don't work. So it's time to ask humans that still have the advantage over AI.

I am trying to create a dynamic calendar that populates based on a given date in another cell, and only showing the next four weeks after that date, and only the weekdays. I would like the date value from the source cell to automatically "land" on the right day of the week in the first week of the dynamic calendar, and display date values accordingly for the rest of the calendar.

The file I'm attaching has the layout where I have the source date and desired output dates where I need them to be so that any help I get will automatically reference the correct cells in my actual working file.

Can someone please help me with this? As I said, AI keeps providing solutions that simply aren't working, and I've wasted more than two hours on trying to figure out what's going wrong.

Thanks in advance!

-Bryan
Sample File for Calendar Example.xlsx