Calendar across Merged cells

[jltjr75]

I am working on a monthly menu planner. The dates are merged between three rows in order to allow breakfast, lunch, and dinner meal items each day. The merged cells are causing the calendar to go from Jul 29, Aug 1, Aug 4, Aug 7 (so on, skipping every three days because of the merged cells).

You can view a screenshot here:
https://drive.google.com/file/d/1a6tOyissUKRHEc6zcILxf8WuWIanRuE_/view?usp=sharing


You can view the excel sheet here:

https://drive.google.com/file/d/1whCZorFmQb-dHhWLcOMNaYbai4dZZSvS/view?usp=sharing

I am using the below code and have tweaked it to no avail.

=$H$2-WEEKDAY($H$2,$D$2)+(ROW(B7:D7)-ROW($B$7:$D$7))/6*7+(COLUMN(B7:D7)-COLUMN($B$7:$D$7)+1)
=$H$2-WEEKDAY($H$2,$D$2)+(ROW(E7:G7)-ROW($B$7:$D$7))/6*7+(COLUMN(E7:G7)-COLUMN($B$7:$D$7)+1)

 

[jmacleary]

If you can get the right date into cell B7 to start with, then just put =B7+1 into E7,=E7+1 into H7 etc.

 

[jltjr75]

Thank you for your support jmacleary. It always seems to be the simple solution. I don't know why I made it so hard. I guess having it formatted as a date is why excel automatically converts the +1 properly to move on to the next month. I was thinking the +1 would keep counting 30, 31, 32, 33, and so on.