Quickly insert a monthly or a yearly calendar in Excel

Sometimes, for some purpose, you may need to insert a monthly or yearly calendar in a workbook. You can use an Excel Calendar Templates to get it done. But with Perpetual Calendar of Kutools for Excel, you can quickly insert a monthly or a yearly calendar in a new workbook.

Insert a monthly calendar
Insert a yearly calendar

Click Kutools Plus >> Worksheet >> Perpetual Calendar, see screenshot:

Insert a monthly calendar

Do as follow to insert a monthly calendar.

1. Click Kutools Plus > Worksheet > Perpetual Calendar, it will display the Perpetual Calendar dialog box. See screenshot:

2. Select the months you want to create the calendar through the From and To drop-down list. See screenshot:

3. Click the Create button, then the monthly calendar is created in a new workbook, See screenshot:

Note: If you check the Include previous/next month box, the last few days of the previous month and the first few days of the next month will be added to each month of the calendar.

4. You can click File > Save to save it.

Insert a yearly calendar

With the function of Perpetual Calendar, insert a yearly calendar is also easy and quick.

1. Click Kutools Plus > Worksheet > Perpetual Calendar. See screenshot:

2. Select January from the From drop-down list and December from the To drop-down list, see screenshot: (By default, it shows the current year in the dialog, you also can select the year from the list.)

Note: If you check the Include previous/next month box, the last few days of the previous month and the first few days of the next month will be added to each month of the calendar.

3. Click the Create button, then the yearly calendar is created in a new workbook. See screenshot:

4. You can click File > Save to save it.

  Create Perpetual Calendar