Hi, I currently have a date in a cell. I'd like to be able to doubleclick it
and it let me change the date. As I'd be away from the keyboard I'd like it
to give me a drop down list of the next 7 days to choose from.

Is this possible?

Thanks in advance!

You could try this.

In M1, add =TODAY()
in M2, =M1+1
Copy M1 down to M7

In you cell add data validation, DataValidation, and set allow type to
List, and in the Source use =M1:M7.

Not double-click, but the cell will have a drop-down that you can click to
expose the list.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"PG Oriel" wrote in message
...
Hi, I currently have a date in a cell. I'd like to be able to doubleclick
it
and it let me change the date. As I'd be away from the keyboard I'd like
it
to give me a drop down list of the next 7 days to choose from.

Is this possible?

Thanks in advance!

Spot on... thanks!

"Bob Phillips" wrote:

You could try this.

In M1, add =TODAY()
in M2, =M1+1
Copy M1 down to M7

In you cell add data validation, DataValidation, and set allow type to
List, and in the Source use =M1:M7.

Not double-click, but the cell will have a drop-down that you can click to
expose the list.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"PG Oriel" wrote in message
...
Hi, I currently have a date in a cell. I'd like to be able to doubleclick
it
and it let me change the date. As I'd be away from the keyboard I'd like
it
to give me a drop down list of the next 7 days to choose from.

Is this possible?

Thanks in advance!