Forum Discussion
KShaff1991
Jun 23, 2022Copper Contributor
excel calendar drop down in column
how to I add a calendar drop down in a column?
5 Replies
Sort By
- mathetesSilver Contributor
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:
- KShaff1991Copper Contributoractually, I just want a generic calendar that someone can pick a date they are entering data on a SS
- mathetesSilver ContributorUnfortunately, 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."