How to add pop-up calendar in spreadsheet cell

PB-04 so if you haven’t already sorted it,  ive worked out, date picker is built in to 365 excel differently. 

if you highlight cells you want the dates in, right click and click on ‘Number Format…’. Select date from the ‘Category’ list and your preferred date layout from the ‘type’ list. It should then add it in with the option for a pop up calendar when you click or double click on the cell

i couldn’t find any answers just alot of the old method and people saying it can’t be done without an add in. My job blocks add in’s so this is how i got it to work. 

PB-04 

In Excel, you can add a pop-up calendar by using the Date Picker control from the Developer tab. Here's a step-by-step guide:

Enable the Developer Tab:

1. Open Excel and go to the "File" tab.
2. Click on "Options."
3. In the Excel Options dialog box, select "Customize Ribbon."
4. In the right column, check the box for "Developer" to enable the Developer tab.
5. Click "OK" to apply the changes.

Insert Date Picker Control:

1. Go to the "Developer" tab in the Excel ribbon.
• If you don't see the Developer tab, make sure you've enabled it as described above.
2. Click on "Insert" in the Controls group.
3. In the "Form Controls" section, click on the "Date Picker" (it might be labeled as "More Controls" in some versions).
4. Your cursor will change to a crosshair. Click and drag on the cell where you want the pop-up calendar to appear.

Configure Date Picker Properties:

1. Right-click on the Date Picker control, and choose "Format Control."
2. In the Format Control dialog box:
• Under the "Control" tab, you can set the linked cell (where the selected date will be placed).
• You can also customize the date format in the "Format" section.
3. Click "OK" to apply the changes.

Use the Date Picker:

1. Click on the cell linked to the Date Picker control.
2. A small calendar icon will appear next to the cell.
3. Click on the calendar icon to open the pop-up calendar.
4. Select the desired date from the calendar.

The selected date will be inserted into the linked cell, and you can use this cell value in your calculations or data.

Note: The availability of the Date Picker control depends on your version of Excel and your system settings. If you can't find the Date Picker, you may need to use alternative methods or third-party solutions. Additionally, some Excel versions might have the "Date and Time Picker" control instead of the "Date Picker." The text and steps were edited with the help of AI.

In order to provide more help, more information is required, such as Excel version, operating system (Win., Mac, etc.), storage medium (Sharepoint, OneDrive, etc.), file extension (.xlsx, xlsm, etc.).

My answers are voluntary and without guarantee!

Hope this will help you.

Was the answer useful? Mark as best response and Like it!

This will help all forum participants.