Open Excel
Select the cell where you want the calendar date picker
Go to File
Click Options
Select Customize Ribbon
Enable the Developer tab
Click OK
Go to the Developer tab
Click Insert
Choose More Controls
Select Microsoft Date and Time Picker Control
Click OK
Draw the calendar control on the worksheet
Right-click the control
Click Properties
Set the linked cell if needed
Save the workbook
If the Date and Time Picker control is not available
Use a calendar template from Excel
Go to File
Click New
Search for Calendar
Choose a calendar template
Click Create
If you want a calendar drop-down in a cell
Use Data Validation with a date rule
Select the cell
Go to Data
Click Data Validation
Set Allow to Date
Set the date limits
Click OK
If you want a pop-up calendar
Use VBA to create a calendar form
Open the VBA editor with Alt + F11
Insert a UserForm
Add a calendar control or date picker code
Assign the form to the target cell