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!

Select the cell where you want this to occur, and click on Data |
Validation. In the pop-up you can choose List from the Allow section,
and then you point to the cells where the list of Saturday dates is in
your sheet (eg you might have put this in X1:X52).

Hope this helps.

Pete

On Sep 30, 1:06*am, GaryK wrote:
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!

We can use a simple data validation pull-down:

In H1 enter: 10/3/2009
In H2 enter: =H1+7 and copy down

Then in your cell insert a Data Validation pull-down referencing this table.


--
Gary''s Student - gsnu200905


"GaryK" wrote:

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!