You could use a calendar control and an event macro to show that control.

See Ron de Bruin's site:
http://www.rondebruin.nl/calendar.htm

Warren Easton wrote:

Dear All,

Is it possible to have a calendar drop down at the RHS of a cell similar to
a data validation drop down list that would allow users to input a date by
just using their mouse?
--
Regards
Warren

--

Dave Peterson