Dynamically populate a Date pulldown menu?
I am trying to make charts based on a range of dates specified by the user.
I am trying to use pull-down menus for both the start and end date that allow the user to choose Month, Day and Year. When the user chooses all three, a fourth cell with =DATE() should gather it all together. But it is surprisingly frustrating. First off, how do you populate the Month list with Jan, Feb, Mar...that equal 1, 2, 3 and not 1/1/1900, 1/2/1900, 1/3/1900, etc...(that ruins everything). I've tried =MONTH(), and then I get 1, 32, 64, 96...no good as well. Second, how can your list know that Feb 2007 only has 28 days, so gray out days 29-31? Third, is there a much better way for people to choose dates? I've seen floating calendar applications, but those seem complex. Experts? Thank you for your time. Arlen |
Dynamically populate a Date pulldown menu?
Just curious, is there a reason that they can't type in a date? You could use
data validation to ensure they type in a date. As a user, I would rather type in one cell, than click on 3 separate drop down menus, that may have a lot of choices (31 days for example). Just my 2 cents. -- John C "Arlen" wrote: I am trying to make charts based on a range of dates specified by the user. I am trying to use pull-down menus for both the start and end date that allow the user to choose Month, Day and Year. When the user chooses all three, a fourth cell with =DATE() should gather it all together. But it is surprisingly frustrating. First off, how do you populate the Month list with Jan, Feb, Mar...that equal 1, 2, 3 and not 1/1/1900, 1/2/1900, 1/3/1900, etc...(that ruins everything). I've tried =MONTH(), and then I get 1, 32, 64, 96...no good as well. Second, how can your list know that Feb 2007 only has 28 days, so gray out days 29-31? Third, is there a much better way for people to choose dates? I've seen floating calendar applications, but those seem complex. Experts? Thank you for your time. Arlen |
All times are GMT +1. The time now is 03:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com