How to use formulas to make calendars in Excel?

1. Enter the text year and month in cell C2/E2 respectively; B4: Enter the English abbreviation Mon/Tues/Wed/Thur/Fri/Sat/Sun from Monday to Sunday in H4 area.

2. Insert two numeric adjustment buttons of two form controls, as shown in the development tool. Insert the number adjustment button to adjust the values of the year and month.

3. Select cell area B5:H 10, right-click to set the cell format (or shortcut key ctrl+ 1), define the number label, and enter "dd" (two letters D) as the type, thus converting the date series value just generated into the format of displaying "day".