Create the quick calendar - Formulas In Excel - Microsoft Excel Tutorials

8.  The quick calendar

To create a simple calendar, use the Fill command in combination with a formula.

To create a quick calendar:

1. Select cell A1 and type the following formula: =TODAY().
2. Select cell B1 and type the following formula: =A1+1.
3. Select cells B1:G1.
4. From the Edit menu, select Fill and Right.
5. In cell A2, type =A1.
6. Drag the bottom-right corner of cell A2 with the mouse cursor rightward through cell E2.
7. From the Format menu, select Cells.
8. Select Custom under Category.
9. Enter the custom format ddd and press OK.

Watch the Video Tutorial - https://www.youtube.com/watch?v=boUQJeQks54

Hope You Like This Tutorial - Give Comments