How would I insert a calendar drop box in excel, e.g. an a dropdown arrow in cell C10 once clicked on brings up calendar to select date.
Any help would be greatly appreciated.
R's
Om
How would I insert a calendar drop box in excel, e.g. an a dropdown arrow in cell C10 once clicked on brings up calendar to select date.
Any help would be greatly appreciated.
R's
Om
Probably it can be done, but I wonder why you want it that way.
I think it is not the quickest solultion.
Probably you want to validatie the input.
That can also be done with datavalidation.
Excel 2003 => data => datavalidation => date
(e..g) between 01-01-2012 and 01-01-2016.
Last edited by oeldere; 07-14-2014 at 10:23 AM. Reason: added excel 2003 etc.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Its a form that people fill in, so we have a start date box that I would like them to click then select the date, and an end date. Bit like booking a flight on line.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks