In excel, I want a drop down box to a calandar to choose dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

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
 
Back
Top