Forum Discussion
Is there a formula that works in Excel that would produce a click on calendar?
Hello Everyone,
Is there a formula anyone can share that creates a DatePicker Calendar?
Are there any formulas that anyone can share to make this functionality a reality.
Thanks in advance for any and all suggestions!
6 Replies
I"m sorry to say it, but what you've written is not clear to me. Could spell out what you want a bit more? Selecting a cell is a simple matter, so it sure looks like you're wanting to do something more.... And formulas per se don't produce clicks on calendars (or anything else, for that matter).
If you've got the start of an Excel spreadsheet or workbook (from which you produced that image), perhaps you could upload it along with your extended description of the purpose you're wanting to serve.
Hi mathetes Thanks for trying to help me! Is there a formula anyone can share that creates a DatePicker Calendar?
- OK, I see.....I think this is a form of data validation, and it's beyond my skill level. It's NOT a formula, though. There are ways to create a drop down list of valid entries for a cell, going from a list. The process you've illustrated here isn't among the ones I've seen. And seems to go beyond what I've seen....
So while you're waiting for someone else, you might try Googling phrases like "advanced date data validation in Excel" or "data validation with calendars" .....
If, on the other hand, you have an actual spreadsheet that does what you're showing....go to the menu across the top, find Data....Validation and see what has been selected there.
