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

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