- First confirm the year, month, and week start; this example chooses Monday and must not default to the regional Sunday. Display dates from adjacent months using mm-dd to avoid misreading the previous month's 31st as the current month's.
- DATE and WEEKDAY determine the first Monday, and the remaining 41 cells reference the same anchor and increment day by day. Keep real date values and date formatting; do not write dates as non-recalculable text.
- Only integer months 1 to 12 are allowed, preventing DATE from automatically rolling month 13 into the next year. Verify leap years using both the actual date function result and an independent date calculation.
- Weekend columns use fill color as a visual aid; this template is not equivalent to regional holidays or shift scheduling rules. After changing the year and month, re-read the 42 cells and verify the number of days in the current month and the start/end boundaries.
First read actual methods, parameters, and sessions and complete parameter templates. Input and example values must be replaced according to the task; for an existing workbook, first check the worksheets and occupied ranges, choose a unique new sheet name for this task, and do not overwrite the original sheet.
When an embedded visual is needed, hand it to the gridcraft-editor skill. Standalone installation:npx skills add full-aigc-skills/gridcraft-skills --skill gridcraft-editor. This batch is a development candidate and has not yet entered a new market version.
The 42 cells are consecutive day by day and the first cell is Monday; February 2028 includes the 29th once; changing to February 2027 has only 28 days. Month 13, missing, or non-integer input clears the date grid and does not generate an incorrect month.
Only handle Gregorian/Excel dates from 1901 to 9999, with Monday as the start, displaying dates from adjacent months; do not assume regional holidays, compensatory time off, or team working days. Each cell is a date formula; items must be placed in a separate area and must not overwrite formulas.
Save as an editable XLSX and reopen it, then modify the input to verify recalculation. The existence of rules does not mean all API writes will enforce input interception; calculation results and exception prompts must be verified. External Excel layout, real business content, and host synchronization are accepted separately.Pin the GitHub source and license。