Date Dropdown Question
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?
|