Forum Discussion
excel calendar drop down in column
how to I add a calendar drop down in a column?
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."
- thank you for the follow up information
IF you are working in fact with a limited set of dates, say for the next two months, and workdays only (or weekends only)...I've created a fancier version of the drop down that includes the day of the week as well as the date. It now looks like this: