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?
Take a look at this:
Pop up calendar for excel (download at bottom)
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.
Here is how date editing may look like if you install XLTools Add-In: