I tried to search for this query in the forum but did not seem to find anything, hence posting it here. (Though sorry if it has already been posted and I failed to find it)
I need to insert a dropdown calendar within the excel worksheet. I found the add-in for Date Picker and was able to install it. However, the option only appears when I right click on the cell. Also, I think the option will only be available if the add-in is installed in the user's computer. As I will be sending the worksheet to different teams, I would like to avoid asking each of them to install the add-in as they might find it complicated.
What I am looking for is something that is straight-forward and similar to data validation wherein when you click on the cell, the calendar will appear and the user will be able to choose the date accordingly. I know that it would be easier to simply type the date but I am exploring an option where this is possible in order to make sure the accuracy of each date entry.
Thanks for your help.
Bookmarks