On Jul 5, 5:52 pm, Sioux wrote:
I am designing a spreadsheet and I want to be able by the use of a drop down
box be able to chose dates. This is to allow the user to be able to look at
a glance and see say three weeks fromtoday without having to resort to
looking up in diary etc. It is the same as when you see a similat thing if
you book flights on line. They show a little calandar and you move pointer
across to click on the date/dates you want.

I have looked all over web and cannot find a resoloution! ANY help most
welcome

If you need a more robust solution, check out http://www.wincalendar.com/excel-calendar.html
.... with this you can pick a date by simply right-clicking on any
existing date. Wincalendar even 'snaps' the the default date value.

regards
Sam