Open Excel
Click the cell where you want the calendar date
Go to the Developer tab
Click Insert
Choose More Controls
Select Microsoft Date and Time Picker Control if available
Click OK
Draw the calendar control on the worksheet
Select a date from the calendar
If the control is not available, use a date cell format instead
Select the target cells
Right-click and choose Format Cells
Choose Date under Number
Apply the desired date format
If needed, insert a calendar template from Excel templates
Go to File
Click New
Search for Calendar
Choose a calendar template
Click Create