Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question

3 Answers 3

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

share|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

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.

share|improve this answer

You can also take a look at our XLTools Popup Calendar Add-In for Excel. It is free and can be downloaded from here.

Here is how date editing may look like if you install XLTools Add-In:

enter image description here

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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