Automating development of calendars of mixed dates and months

Dear Experts

I am trying to develop calendars of mixed months and dates (see attached example).

1) This calendar starts from Sunday to Saturday;
2) Each calendar shows 4 weeks (see attached);
3) Can have days and dates referring to both current and next months;
4) The last row (week) repeats on the next spreadsheet representing the new 4-weekly calendar and the remaining rows (weeks) are filled with subsequent dates (see the sheet titled "Jan2019-Feb2019".
5) Dates and months can refer to the previous year (e.g. December refers to 2018 and January dates refer to 2019, etc - see attached);

Question:
How to automate these calendars so that they can automatically fill correct dates and months in each subsequent linked sheets correctly for three years?
(i.e. current year and 2 future years; or partial past year - like above example - and then current 2019 to 2021)

I appreciate your assistance with my query.

Simon

Dear All

Any response to my query? I hope someone there can help.

Regards,
Simon

Many thanks Bo_Ry for your help.

I filled the first sheet with your suggested formula which worked very well, but could not progress correctly to the second sheet in order to fill the dates and months on it.
I tried to link the last row of the first sheet to the second sheet to guide the new days and months in the second sheet where some dates would be in February (in this example).
[1] But, I could not get the formula to put the correct dates and months in cells in other rows. What changes in the formula are required to solve the problem?
[2] Also, if I use just one cell for the name of the months (mmmm)instead of currently two merged cells, then what adjustments to the formula is needed?

I appreciate your further comments so that I can automate the calendar in all sheets in my workbook.

Best Regards,

Simon

Hi Bo_Ry

Thanks for reply. please see the attached (v2 of the file before containing your suggested formula and other linked sheets).

The first row of the second tab is linked to the last row of the first tab; the first row of the third tab is linked to the last row of the second tab; and so on.

How to adjust the formula to work based on the cells' data in the first row of second, third, fourth, . . . tabs?

Best Regards,
Simon

Hi Bo_Ry

Indeed I am thankful for your reply. We are getting closer to the solution but not yet there.

Is it possible to change the content of the cell "C1" instead of "Dec2018" in sheet one, or "Jan2019" "Feb2019" in other sheets to a given day, month and year?
For example instead of "Dec2018", the formula refers to a given full date of "30Dec2018", or in the second sheet it refers to "20Jan2019", or in the third sheet it refers to "10Feb2019", etc.
This way I can build a 30 days calendar which starts from the date written in the cell "C1".

My aim is to have a custom made calendar so that the last week of the previous month (i.e. the last row of the calendar in sheet one becomes the first week of
the second sheet calendar. Likewise, the last week (last row) of the dates in the second sheet becomes the first week of the third sheet calendar. Please see the excel v2 file which I attached to my last email.

I think, if you help me by a solution that the calendar can be completed automatically based on a starting date which is specified in cell C1 then the problem is solved.

I look forward to your receiving your suggestion.

Best Regards,
Simon