up vote 1 down vote favorite
share [g+] share [fb]

I'd like to setup an entire column, so that it will only contain dates, and I won't have to manully enter the date string. Instead, I'd like a click on the cell to pop up a calender selector.

How can I do that?

link|improve this question
64% accept rate
feedback

2 Answers

up vote 2 down vote accepted

Take a look at this:

Pop up calendar for excel (download at bottom)

OR

EDIT:

The link below was the solution that worked for the asker of the question.

Other popup calendar

OR

Yet another pop calendar

link|improve this answer
Isn't there something built in? – ripper234 Oct 24 '09 at 16:01
1  
The calendar control is built-in, you just need to apply a little bit of code to get the results you are looking for, however if you are looking for an add-on hidden in the menu, it does not exist. – ricbax Oct 24 '09 at 16:20
The second link worked for me, thanks. – ripper234 Oct 24 '09 at 16:42
Ripper234 could you please accept this as the answer? Thanks. – ricbax Oct 24 '09 at 23:09
Yes, just edit it to indicate what actually worked for me (actually I was asking it for a friend, and he said the first link wasn't good ... I can't really tell you what was wrong with it). – ripper234 Oct 25 '09 at 9:50
feedback
up vote 1 down vote

Not sure if this will help or not ...

You do not always have to enter the entire date in Excel

If you type "10/12" excel will assume 10/12/2009

You can format the cell to display the date in a wide range of formats. If you format the cell to show say the whole date, for example format dddd mmmm/dd/yyyy then excel will show Monday October/12/2009

if you type 1/2/3 in the cell then excel will show Thursday January/02/2003

Personally, I find this style of date entry a lot easier that clicking through pop-up calendars.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.