Another way to do it is by inserting a Calendar Control. The Calendar Control is an ActiveX control. If you work in Access, you have probably used controls, such as combo and text box controls. This method allows you to insert a calendar to an area of the worksheet. You can refer to this calendar at any time, moving forward or backward from month to month.
To add a Calendar Control to Excel 2003, begin by clicking on a cell in the area of the spreadsheet where you want to make a calendar. Go to the Insert menu and click on Object. On the Create New tab of the Object dialog box, click Calendar Control and then click OK.
In Excel 2007, go to the Developer tab of the ribbon and click Insert. Select ActiveX Controls and then More Controls. Select Calendar Control and click OK. If you don't see the Developer tab, click the Office Button and then click Excel Options at the bottom of the menu. On the Popular tab of the Excel Options window, select Show Developer Tab in Ribbon.
If you do not see the Calendar Control option in either version of Excel, it may be because it is installed with Access. You can download the Control here.
The calendar will open in Design View. To make the calendar a bit more custom, remain in Design View. Right click the Calendar Control, point to Calendar Object and select Properties. Use settings on the Calendar Properties dialog to make the Calendar in your Excel spreadsheet look the way you want. You can use VBA to control how the calendar looks and acts as well. Simply double click the Calendar Control to open Visual Basic.