Data Validation Query

[grf]

Hi Experts,
I have a query concerning the production of a Data Validation list.
I want the list to consist of 2 dates. The date which appears in the current cell above the cursor and the date 1 day after that which appears in the current cell above the cursor.
Is this possible?
Regards Graham

 

[crazydragon84]

in the cell above, can you add a column that has +1 date as cell above? then you can do list as cell above or offset 1. Like in below, have the 1/1/17 be 12/31 + 1 and Active cell will have list of 12/31 and 1/1

12/31/16 1/1/17
Active Cell

 

[Jeffrey Mahoney]

In cell H2 I put the date 12/31/2016
In Cell I2 I put this formula: =IF(H2<>"",H2,I1+1) and copied that down
In Cell H3 I put this Data Validation Formula as a List: =OFFSET(H3,-1,1,2,1) and copied that down.

Now you can choose the previous date or the next date.

 

[grf]

crazydragon84, thank you very much for your help, and Jeffrey Mahoney, your formulas worked a treat. Thanks again, I'm very grateful
Regards, Graham