1. First, make a general template with a table, as shown in the following figure:

2. Enter the current month in the month column, then choose to use the cell format, find the date type in the settings and change it to "Year/Month/Day" mode; Select the d2 cell and enter =d1, then enter d2+1 in the e2 cell, then fill it backwards, and so on; Finally, select all the cells from d2 to e2, and set the cells, and define them as type "D".

3. Select the whole row of d3 cells, then set it to d3=d2, continue to select backward padding, and then select the cells from d3 to h3 to set them, and customize them to "aaa", which will automatically display the corresponding week after setting.

4. Because the number of days in each month is not the same, it is necessary to automatically match the number of days in the month and the current month. So, select the last three columns, select the conditional format and create new rules, and change the cells with formulas.

then find "custom" in "number" in "formatting" and make changes, and enter "; ; ；” , so that you can automatically hide the extra days.

the publicity is: =MONTH(AF2)> MONTH(D2)