Start Using Date Picker now in Excel
Excel itself doesn't have a built-in date picker feature like some other applications. However, you have two options to achieve a similar functionality:
ActiveX Date and Time Picker Control:
Enable the Developer tab (if it's hidden). You can search for instructions online.
Go to the Developer tab, click "Design Mode."
Click "Insert" and then "More Controls."
Find "Microsoft Date and Time Picker Control 6.0 (SP6)" in the list, select it, and click "OK."
Place the date picker on your sheet.
Right-click the date picker and choose "Properties."
Set the "Linked Cell" property to the cell where you want the selected date to be inserted.
Click "Design Mode" again to deactivate it.