Forum Discussion
Date & Time Picker Help
Although it might not be exactly what you are looking for, but it's good to know about some options available as add-inns in the Microsoft Store.
I frequently use in my projects the "Mini Calendar and Date Picker" to add any date to a cell with a click. I also see in the Microsoft Store a "Date and Time" add in but I did not use it before. You may try it.
To access FREE add-ins from the Microsoft Store, go to the insert Tab >> Get Add-ins >> Office Add-ins >> Search >> Select what you want >> click Add.
Note some Add-ins are not free.
Hope that helps
Nabil Mourad
Hi, nabilmourad
Thanks so much for your reply, however I'm doing this on my work computer and my organisation has configured our systems to block ad ins.
Do you have any other suggestions? Is there a formula I can use to achieve this? Or how I can use the macros to have 2 instances of Date and Time picker in the same spreadsheet?
Thanks