I have a column full of dates, ranging from 1/4/2004 onwards in A2:A400
Another cell (B1) contains a validation list of each of the values in A2:A400.

What I would like to do, if possible (?) in B2 is reference the value in B1 and take the first previous date.

For example: If B1 said 31/12/2004, then B2 would show 30/12/2004, and if B1 said 1/1/2005 then B2 would return 31/12/2004.

Is this at all possible ? The reason I am asking is so that using a vlookup I can select a date with associated data and in the next line show the previous days data.

Many thanks for your help.
Scott