Traditional Culture Encyclopedia - Almanac inquiry - How to make a calendar with WPS form

How to make a calendar with WPS form

List the year and month in the cell.

Make a drop-down menu of the year and month with data validity.

Edit the formula "= if (month (date ($ b $ 1, $ d $ 1, column (a $ 1)+ row ($ a 1)* 7-7))= $ d $65438. Set the cell format to: Custom-"D".

Pull the formula to the right by 7 cells (representing one week), and then pull down by 5 rows.

Edit the formula "= TEXT(B3," AAA ")" in cell B2, and drag the formula to the right by 7 cells.

Ok, the calendar is ready. Next, set the table style according to your own preferences. Saturday and Sunday can be marked in conditional format.