I'd like to create a dropdown where the user selects a date. However, I'd
rather not use data validation. Data validation requires that I have a
column somewhere filled with dates. I'd like the dropdown to have those
dates going backward from today's dates - forward dates are not allowed.

Thoughts?

Hi

Why can't the Validation list have dates going backwards?
In cell A1 =Today()
In A2 =A1-1
Copy down for as many dates as you want in your validation range.


--
Regards

Roger Govier


"Paperback Writer" wrote in
message ...
I'd like to create a dropdown where the user selects a date. However,
I'd
rather not use data validation. Data validation requires that I have
a
column somewhere filled with dates. I'd like the dropdown to have
those
dates going backward from today's dates - forward dates are not
allowed.

Thoughts?

You could enter a list of dates on a separate worksheet.

In A1 enter =Today()

In A2 enter =A1-1

Drag/copy A2 down as far as you wish.

Select the list and InsertNameDefine

Go back to original sheet and select a cell and DV

In source enter =mynamedlist


Gord Dibben MS Excel MVP

On Mon, 27 Nov 2006 12:48:01 -0800, Paperback Writer
wrote:

I'd like to create a dropdown where the user selects a date. However, I'd
rather not use data validation. Data validation requires that I have a
column somewhere filled with dates. I'd like the dropdown to have those
dates going backward from today's dates - forward dates are not allowed.

Thoughts?

There are instructions here for adding the Generate GetPivotData button
to a toolbar, and toggling the feature on and off:

http://www.contextures.com/xlPivot06.html


Paperback Writer wrote:
I'd like to create a dropdown where the user selects a date. However, I'd
rather not use data validation. Data validation requires that I have a
column somewhere filled with dates. I'd like the dropdown to have those
dates going backward from today's dates - forward dates are not allowed.

Thoughts?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html