How excel Makes Calendar Schedule

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 the cell format.

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 entering the date in the first column, enter the to-do list 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. R is for 5, pick it out. You can choose the format,

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

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