Forum Discussion
excel calendar drop down in column
how to I add a calendar drop down in a column?
5 Replies
I'm guessing at one possible meaning behind your question. You'll find that solution in the attached spreadsheet. If that's not what you had in mind, please come back with a more complete description.
This one assumes that you have in minds some sort of monthly deadlines, or monthly meetings....and those dates are known.... So the drop down goes from a list of those known dates. It looks like this:
- actually, I just want a generic calendar that someone can pick a date they are entering data on a SS
- Unfortunately, the data validation doesn't have that capability at present. You can specify start and end dates, but beyond that, they're on their own in terms of knowing where in the week a given date might fall (which would be part of the advantage of seeing a "generic calendar."
