Calendar How to make a calendar in 2022

1. Create a new blank EXCEL document.

2. Then enter the date in the first column and then enter the date in the second column.

3. Select the second column, then right-click and select Format Cells.

4. Select "Custom" in the number, enter "aaaa" in the General Type, and then click OK. So one day of the week.

5. Then enter the to-do list in the third column.

Method 2:

1. After the date is entered in the first column, the to-do list is entered in the second column.

2. Select the first column, and then click Format-Conditional Format on the menu.

3. select "formula" in the condition 1, and then enter = weekday ($ a2,2) >; 5, $A2 means the referenced cell, 2 means Sunday = 1, and Saturday =7. C is for > 5, pick it out. You can choose the format,

4. Select "Format". > 5 is bold, and the unit cell is yellow.

5. Click "OK". So Friday and Saturday will be shown in bold.