CREATE A QUICK CALENDAR USING MICROSOFT EXCEL

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.

CREATE A QUICK CALENDAR USING MICROSOFT EXCEL

Watch the Video Tutorial


Formulas in Excel, Microsoft Excel Tutorials, Microsoft Excel Video Tutorials, Macro Lessons In Excel, Macro Tutorials, Create a quick calendar using Microsoft Excel