Date picker in Excel/Adding a drop down calendar.

I need to have a date entered in Column Q, I'd like this to be done with a simple drop down calendar. I cannot find the "Date Picker". I've tried in excel 2007 and 2010, read a little about adding the function but it does not succeed on every attempt. Seems like a very simple task is turning out to be difficult.
LVL 1
McottuliAsked:
Who is Participating?
 
Naresh PatelTraderCommented:
ok how bat this one ..but you have to do lots of work on it....Calendar

Thanks
0
 
Naresh PatelTraderCommented:
See attached I hade created WB. if you are looking for like this  then pls reply I will guide you how to do it.
 in cell Q1 you have to select Month in dropdown & Cell Q2 you have to select date in dropdown for that month.

Thanks
Calendar.xlsx
0
 
McottuliAuthor Commented:
Thank you. The month/day/year must be in one cell. Was actually looking for a calendar to appear so they could choose directly from a calendar.
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
Naresh PatelTraderCommented:
follow this link, I dint tested Calendar Drop Down

Thanks
0
 
McottuliAuthor Commented:
I've tried that, the problem is that the "Microsoft date and time picker control" is not an option. It's just not there, i've tried to install it with no luck!
0
 
Naresh PatelTraderCommented:
see there is 2 workbook is also available for download at the bottom of the text.

Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.