creating a "date selector box" or "pull down box" in a cell
Not sure what to call this, but I have a cell set up to type the date for
every Saturday in a weekly report.
Rather than typing the date for each & every Saturday, I would like to click
a down arrow and select a given Saturday from a list, and have that date
appear in the box. Or have a little calendar show up where I can click on a
day of the month, which I could use in other reports.
I have Excel 2007 & 2008(Mac)
Thanks!
|